ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printing a long spreadsheet on 1 page only?? (https://www.excelbanter.com/excel-programming/435360-printing-long-spreadsheet-1-page-only.html)

Robert Crandal

Printing a long spreadsheet on 1 page only??
 
I enter data into my spreadsheet from left to right, starting from
Cell A1 up to Cell T1. This looks good on screen, but it
requires 2 sheets of paper when printing.

Is it possible to tell Excel to somehow print my long
spreadsheet sideways or upside down so that it prints on
the long side of the paper so it fits on 1 page only??

Thank you!



JBeaucaire[_131_]

Printing a long spreadsheet on 1 page only??
 
1) Highlight the range of cells, widthwise, that you want to print, then
select
FILE PRINT AREA SET PRINT AREA

2) Then select FILE PAGE SETUP Page: Orientation: Landscape
3) Also use the SCALING options if you wish to limit the # of pages used.

Does that help?
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Robert Crandal" wrote:

I enter data into my spreadsheet from left to right, starting from
Cell A1 up to Cell T1. This looks good on screen, but it
requires 2 sheets of paper when printing.

Is it possible to tell Excel to somehow print my long
spreadsheet sideways or upside down so that it prints on
the long side of the paper so it fits on 1 page only??

Thank you!


.


Robert Crandal

Printing a long spreadsheet on 1 page only??
 
I had already been playing around with the "Print area" and the
"landscape" options.... but those "scaling" options finally got
it working to my liking.

Thanks soo much!

"JBeaucaire" wrote in message
...
1) Highlight the range of cells, widthwise, that you want to print, then
select
FILE PRINT AREA SET PRINT AREA

2) Then select FILE PAGE SETUP Page: Orientation: Landscape
3) Also use the SCALING options if you wish to limit the # of pages used.

Does that help?




All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com