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
add comment

2 Answers

up vote 2 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
add comment

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
add comment

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.