3
2
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.
burtek
Posted 2012-07-14T09:33:36.990
Reputation: 533
4
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.
billc.cn
Posted 2012-07-14T09:33:36.990
Reputation: 6 821
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.
Daniel
Posted 2012-07-14T09:33:36.990
Reputation: 654
1-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 – 2015-04-23T12:07:56.227
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 – 2015-04-23T13:05:41.793
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 – 2012-07-14T18:40:01.740
2
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.
Andi Mohr
Posted 2012-07-14T09:33:36.990
Reputation: 3 750
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 – 2015-04-23T12:46:57.127
1It'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 – 2015-04-23T13:52:10.667
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: http://www.knowledgewave.com/blog/msoffice/excel/excel-2013-use-the-camera-tool-to-print-multiple-sheets-on-a-single-page.html
– Andi Mohr – 2015-04-23T13:54:11.030I do now have Excel 2013 and haven't had any trouble with the camera tool - it's unchanged from the 2010 version. Let me know if you're still having problems @Prasanna – Andi Mohr – 2015-07-06T08:37:19.473
0
A lot of people keep saying the same thing, but it isn't the answer you seek. Try this if you are like me and had to figure it out yourself. Go to the Page Layout tab, if you have the more modern day office. Highlight what you want to fit onto 1 page. Now look for the tiny arrow just to the right of Page Setup and click it. Page Setup pops up. Select the option "Fit to: ? page(s) wide by ? tall". In this area, choose 1 each box. Click OK. Now print, and make sure before you ok that it will print onto 1 page. I had to discover this on my own and had no help, because everywhere I looked, I couldn't find the answer. Hope this works for you. SW
SWest
Posted 2012-07-14T09:33:36.990
Reputation: 1
Can you explain more the "change the scaling options to fit all columns in one page" ? – thanos.a – 2015-11-13T08:41:41.743
1@sakis.a It's the option to fit multiple pages on one sheet. – billc.cn – 2015-11-14T09:37:44.997