ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing Multiple pages one one page (https://www.excelbanter.com/excel-discussion-misc-queries/141047-printing-multiple-pages-one-one-page.html)

glee138

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?



bj

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?



Dave Peterson

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