Printing Multiple pages one one page
I have an excel document that is 4 pages long but only a few columns wide.
When I print the spreadsheet it's long, but wastes so much paper? How can I make it so that all four pages prints one one page? |
Printing Multiple pages one one page
the simplest way is to make a page specifically for printing where you wrap
the columns in one page. "glee138" wrote: I have an excel document that is 4 pages long but only a few columns wide. When I print the spreadsheet it's long, but wastes so much paper? How can I make it so that all four pages prints one one page? |
Printing Multiple pages one one page
I like to copy the data into MSWord and use MSWord's builtin ability to do
column layout. With lots of data, I sometimes have to paste into Notepad first--large tables cause me trouble in MSWord. If that doesn't work for you, David McRitchie has a macro that will "snake" the columns. http://www.mvps.org/dmcritchie/excel/snakecol.htm If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm glee138 wrote: I have an excel document that is 4 pages long but only a few columns wide. When I print the spreadsheet it's long, but wastes so much paper? How can I make it so that all four pages prints one one page? -- Dave Peterson |
All times are GMT +1. The time now is 06:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com