Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a table in Excel. It is 2 pages long, but only half-page wide. Is there a way to print both parts of this table on one page, so one next to another? I don't want to move the data, I would like to know whether this is possible through the printing or page settings.

share|improve this question

3 Answers 3

up vote 3 down vote accepted

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.

share|improve this answer

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.

share|improve this answer
    
You can also flip from portrait to landscape (or vice-versa), which would allow more to be on the page after making it into one page using the Page Break Preview. VERY handy option, useful for compressing output onto fewer pages, or onto a specific page count. –  lornix Jul 14 '12 at 18:40
    
-1. Doesn't answer the question, specifically it doesn't address how to print one [page] next to another. Page Break Preview simply allows you to move the row on which the page breaks. –  Andi Mohr Apr 23 at 12:07
1  
@AndiMohr Fair enough. After re-reading the question this is clearly an answer to a different question. Btw, Page Break Preview lets you adjust rows and columns. but wouldn't help the OP with this problem. –  Daniel Cook Apr 23 at 13:05

You could use an amazing Excel function very few people no 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):

enter image description here

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

enter image description here

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.

enter image description here

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.

share|improve this answer
    
Just curious to know - how is it different from snipping tool? I'm using Excel 2013 - and it is really difficult to use this Camera tool in Excel –  Prasanna Apr 23 at 12:46
    
It's different because the image produced by the Camera tool is not static. If you use the snipping tool and then your data changes, then you'll have to take a new screengrab with the snipping tool. The camera tool however, immediately updates when the data changes. Thanks for asking - I've called this out to draw attention to it in my answer. –  Andi Mohr Apr 23 at 13:52
    
Don't have Excel 2013 so I'm afraid I can't guide you on how to use it there. This might be worth a look though: knowledgewave.com/blog/msoffice/excel/… –  Andi Mohr Apr 23 at 13:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.