Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need to print the exact freeze pane or hide column (excel 2000)

    I am working with a sheet that has a large number of columns. I freeze columns A & B, move column G adjacent to B, apply a filter to G and I need to print the resulting three columns (A,B,G etc.). I have tried it many different ways (including hiding columns C-F instead of freezing) but I can't get the printout I want. At the moment I manage with a screendump. Can anyone give me a solution? I'd appreciate your help.

    Thanks

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Need to print the exact freeze pane or hide column (excel 2000)

    How is your Page Setup | Sheet dialog set up? Can you describe in more detail what you want that you are not getting?
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need to print the exact freeze pane or hide column (excel 2000)

    You state that hiding columns C through F doesn't yield the desired result. That workaround looks OK on my PC - how is it unsatisfactory on yours?

  4. #4
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need to print the exact freeze pane or hide column (excel 2000)

    jdss:

    Freeze panes only affects the screen view, not the printout. However, hidden columns shouldn't print. As a possible solution, have you tried hiding columns C to F, selecting the region you want to print then choosing 'Selection' from the Print Dialog? Shouldn't make a difference, but I have a vague memory that it might.

    If that is no help, have a look at <!post=this thread,23502>this thread<!/post> ref. copy/paste picture as a possible workaround.

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Need to print the exact freeze pane or hide column (excel 2000)

    What about JUST setting Col G as the print area and print A&B as columns to repeat on left?

    File - page setup- sheet tab
    Print area : G:G or whatever region in G
    Columns to repeat at left = A:B

    No need to hide anything.

    Steve

  6. #6
    New Lounger
    Join Date
    May 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need to print the exact freeze pane or hide column (excel 2000)

    Thanks Tony and everyone else for your suggestions. I found that hiding the columns(Format>Column>Hide), selecting the cells I want to print and choosing the "Selection" option from the Print What menu works. I had difficulty unhiding the columns after using Format>Column>Unhide and had to undo the changes to get them back. Eventually figured out that it would unhide if I highlighted a row of cells across the columns (i.e. A,B,G,H).

    Thanks everyone for your help.

  7. #7
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need to print the exact freeze pane or hide column (excel 2000)

    jdss:

    Another way to ensure all columns are unhidden is to select the whole worksheet (CRTL/SHIFT/SPACEBAR), right-click on any column heading and Unhide.

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Need to print the exact freeze pane or hide column (excel 2000)

    FYI, some additional tips on slecting the entire worksheet

    Ctrl-a will also select the entire worksheet
    Also
    select the square that is to the left of the column Heading A, above the row heading 1 will also select the entire worksheet.

    Steve

  9. #9
    New Lounger
    Join Date
    May 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need to print the exact freeze pane or hide column (excel 2000)

    Thanks for the tips. Although I knew them already, I am sure they will help others. You have all helped make my work a LOT easier, considering the amount of time I wasted trying to print what I wanted. In future, I know where to go for help.
    Thanks again to you all.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •