Printing Side By Side Pages

Topic

New Reply

In Excel 97 or 2000, is there any way to print 2 pages side by side on the same sheet of paper (like you can in Word with WOPR)?

Reply | Quote

Replies

There is no inbuilt way but you could use a workaround. Set up a link on a separate sheet which contain references to the two pages you want to print. It might be a good idea to leave a narrow column between the two pages. Set the page orientation to landscape and set the scaling to 1 page(s) Wide by 1 tall. Set the margins to suit and center horizontally and vertically. It is a bit convoluted, but the best way I know without recourse to even more convoluted macros.

Andrew C

Reply | Quote

Use the camera (Tools menu/Customise/Commands/Tools, and drag the camera onto a toolbar). Select your first sheet, click on the camera, go to a blank sheet and drop and size a copy onto this sheet. Repeat for the second sheet.

Reply | Quote

Thanks for the tip. I’ve never used the camera before, but it works great.

Reply | Quote