LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 82
Default How to PRINT all worksheets at once

1- First you have to set the page one of all 80 sheets.
This could be done by clicking sheet 1, holding shift key and then clicking
sheet 80. Now all your 80 sheets are selected (sheet tab's are white).
2- In the active sheet (which ever it is) go to file/set print area. Select
page one. (In this manner page one of all 80 sheets will be selected)
3- Now go to print command and select "all workbook". This will print all 80
sheets of your work book. The default is active sheet, which prints only
active sheet.
4- Check all your 80 sheets before performing the print all work book,
because once you lunch it, you can not stop printing 80 sheets unless it if
finished and if you have a mistake you have to do it again. I recommend to
print each 10 sheets separately.
HTH.

"Tom" wrote in message
...
WinXP Pro SP2
Excel 2003 SP2
I have a spreadsheet with about 80-ish worksheets. Each worksheet spreads
over multiple pages. I only need the FIRST page of ALL worksheets on a
SEPARATE page on output.
How can I with ONE print to the printer have ALL PAGE 1 of the worksheets
print off in a non-duplex mode?
Can this be done instead of individually selecting EACH worksheet and then
selecting PRINT?
TIA


 
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
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
how can i print my worksheets as book schunker New Users to Excel 1 July 21st 06 08:05 PM
How to copy print set up to other excel worksheets? mcwhirter Setting up and Configuration of Excel 1 July 7th 06 12:30 AM
What is the simplest way to print multiple worksheets? substring Charts and Charting in Excel 1 April 21st 05 11:49 PM
how can I get all worksheets to print at one time? Sofia Excel Worksheet Functions 2 April 19th 05 07:13 PM


All times are GMT +1. The time now is 01:27 AM.

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

About Us

"It's about Microsoft Excel"