Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Location
    Maryland
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print Area (2000/SR-1)

    In a multi column sheet, I've hidden several columns. When I do a print preview, I end up with the first unhidden column shown by itself and the ones after the hidden columns shown on next page. I've reset print area and tried print preview - page break preview. The first doesn't correct it and the second does not allow me to move page break shown.

    Entirely frustratedbut knowing it's gotta be simple!

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Print Area (2000/SR-1)

    Have you tried unhiding the hidden columns, setting the page break and then rehiding?

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    New Lounger
    Join Date
    Nov 2001
    Location
    Maryland
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Area (2000/SR-1)

    Thanks! I can't figure out why I've never run into thi sbefore but you helped me to meet a deadline this weekend <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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