Is there a way to fit two pages on one page in MS Excel when printing?

Solution 1:

Something you can try:

(This assumes you're using ISO A4 paper and Office 2007+, but the general idea is sound for other occasions.)

Change the paper size to A5 portrait, select only the columns with data and select Page layout -> Print Area -> Set print area.

In the print pane, change the scaling options to fit all columns in one page. Then change printer properties to print the two A5 sheets on one A4.

Solution 2:

Switch to Page Break Preview. If you do not like the designate pages, then move the lines and Excel will print it as you dictate.

If it ends up crunching too much horizontal data, go to the print preview and in the setup switch to landscape mode. The main point is that you can tell excel exactly how to print your cells.

Solution 3:

You could use an amazing Excel function very few people know about. Don't know why it's been kept such a secret but it's a very nifty feature!

Excel Camera Tool

To use the Camera tool, you need to customise your toolbars.

In Excel 2007, this looks something like this (image from Chandoo):

In Excel 2010 you can add it to your Quick Access Toolbar:

Select the range you want to appear in the right "column", then click the Camera tool button. The cursor will change to a cross. Now click wherever you want your right "column" to appear.

You should get something like this.

Position as you like, and remove the border (if you want) by right-clicking the image and selecting Format Picture.

Now set your print area to be the left and right columns (excluding the rows below your left column).

What makes the Camera Tool so Great?

The wonderful thing about the camera image is that it's not static - if your data changes, the camera image will also change, automatically. It's a great tool!

Brilliant for complex layouts

For simple scenarios like this, it may be overkill but if you have several areas you want to display next to each other (especially with different column widths, row heights etc) the Camera tool really comes into its own.