Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I find a worksheet tab in a spreadsheet with multiple tabs? Mickey Mouse Tiger Excel Discussion (Misc queries) 4 June 3rd 09 08:10 PM
Printing multiple tabs AGM Excel Discussion (Misc queries) 2 June 3rd 09 05:55 PM
Problem Printing Multiple tabs bbddvv Excel Discussion (Misc queries) 2 July 11th 06 07:56 PM
Multiple Files & Tabs Printing Options gallan Excel Discussion (Misc queries) 0 May 1st 06 02:31 PM
printing multiple sheet tabs to image file 0492-Examiner Excel Discussion (Misc queries) 0 October 19th 05 10:43 PM


All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"