Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing A4-ISO paper size on 8.5 X 11 (Excel 97/SR-2)

    I have a workbook with over 100 worksheets that I received from Korea. I have to print all the worksheets on 8.5 x 11" paper but they're all set up on A4-ISO (210 x 297 mm). If I select all the worksheets and change the page setup, it only changes the active worksheet. How can I change them all at once to print on 8.5 x 11"?
    Thanks,
    Caroline in lala-land

  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: Printing A4-ISO paper size on 8.5 X 11 (Excel 97/SR-2)

    Try grouping the worksheets together.

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

  3. #3
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing A4-ISO paper size on 8.5 X 11 (Excel 97/SR-2)

    I did group them together, but when I change the page setup it only changes the active worksheet not all the worksheets. Any other suggestions?
    Thanks,
    Caroline in lala-land

  4. #4
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Sault Ste. Marie, Michigan, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing A4-ISO paper size on 8.5 X 11 (Excel 97/SR-2)


  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Printing A4-ISO paper size on 8.5 X 11 (Excel 97/SR-2)

    I think this may be what you need.

    Open the Spreadsheet at the first (leftmost) sheet. Press the Shift key and then select the tab of the last sheet - you should now have selected all sheets. Now proceed to change you paper size.

    You may also find that if you go to File Print and check the Properties button you may have an option for your printer to resize to your currently loaded paper, or that may even be a hardware option on the printer itself. This may be easier than changing the paper size because you may find that after changing the paper size what was on two pages now prints on three in an unmanageable format.

    If you have a hundred sheets make sure you try your results before you print it all.

    Good Luck!

  6. #6
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing A4-ISO paper size on 8.5 X 11 (Excel 97/SR-2)

    I LOVE this place!!! Thank you so much -- it worked like a charm. <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    Thanks,
    Caroline in lala-land

  7. #7
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing A4-ISO paper size on 8.5 X 11 (Excel 97/SR-2)

    I tried this and it didn't work for all the sheets. However, I did use the F4 procedure mentioned above and that worked beautifully.
    Thanks,
    Caroline in lala-land

Posting Permissions

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