Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I print multiple print areas on one page
I have a wide worksheet that is not very deep i.e. lots of columns but not
many rows. I have it in landscape but it is still too wide to go on one page. I would like to be able to print the right hand side of the worksheet underneath the left hand side of the worksheet, on one page, rather than having to print out two pages. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I print multiple print areas on one page
This is a common question. The only way to do this is to create what you
want printed. In other words, copy all of your data to a blank sheet, then cut/paste to get what you want, then print it. You can do this with a macro and never see what is happening in the background. Post back if you want to pursue the macro idea. If so, provide some detail about what rows of data you have and what columns you want moved for printing. HTH Otto "Leo18" wrote in message ... I have a wide worksheet that is not very deep i.e. lots of columns but not many rows. I have it in landscape but it is still too wide to go on one page. I would like to be able to print the right hand side of the worksheet underneath the left hand side of the worksheet, on one page, rather than having to print out two pages. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I adjust print scaling for multiple print areas on the same sh | Excel Discussion (Misc queries) | |||
print areas on one page to print? | Excel Discussion (Misc queries) | |||
How to Print different areas on one page | Excel Discussion (Misc queries) | |||
Can i print non-contiguous areas on one page?? | Excel Discussion (Misc queries) | |||
Can i print non-contiguous areas on one page | Excel Worksheet Functions |