ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing of multiple tabs within the same spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/250635-printing-multiple-tabs-within-same-spreadsheet.html)

Ron H

Printing of multiple tabs within the same spreadsheet
 
I hae a spreadsheet with 30 tabs, each formatted the same. I want to print
all of the tabs, front to back landscape.
I have tried hilighting all the tabs, then select the print option, 1 page
print from top.
It does not work.
Can anyone point me in the right direction?
Thank you,
Ron
--
rshfl

Sklyn

Printing of multiple tabs within the same spreadsheet
 
Hi Ron,

Go to FilePrint or press Ctrl+P
Then under "Print What" in the window that opens check the Entire Workbook
button. This will print the entire book.

Would also pay to go through all the print options and Page Setup options to
adjust landscape view and print orders.

Use print preview to how ur changes will turn out.

Cheers
Sklyn.


"Ron H" wrote:

I hae a spreadsheet with 30 tabs, each formatted the same. I want to print
all of the tabs, front to back landscape.
I have tried hilighting all the tabs, then select the print option, 1 page
print from top.
It does not work.
Can anyone point me in the right direction?
Thank you,
Ron
--
rshfl



All times are GMT +1. The time now is 01:28 PM.

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