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

Topic

New Reply

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″?

Reply | Quote

Replies

Try grouping the worksheets together.

Cheers

Reply | Quote

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?

Reply | Quote

Copy Page Setup Instructions

Reply | Quote

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!

Reply | Quote

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.

Reply | Quote

I LOVE this place!!! Thank you so much — it worked like a charm.

Reply | Quote