Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic page numbering with multiple sheets in a workbook
Currently I have a workbook with 5 worksheets. If I print each worksheet
separately, there would be 12 pages in total. I want to have consecutive page numbering on all the sheets so that the page numbering is from 1 to 12 instead of page 1 of 2, page 1 of 3, etc. Is this possible with Excel? Thanks Julie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic page numbering with multiple sheets in a workbook
Simply select all the sheet tabs before printing.
Click in the first, hold down <Shift, and click in the last ... then print. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "forest8" wrote in message ... Currently I have a workbook with 5 worksheets. If I print each worksheet separately, there would be 12 pages in total. I want to have consecutive page numbering on all the sheets so that the page numbering is from 1 to 12 instead of page 1 of 2, page 1 of 3, etc. Is this possible with Excel? Thanks Julie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic page numbering with multiple sheets in a workbook
Julie,
Make sure that for all the sheets, the "First page number" box (File - Page setup - Page tab) is set to "Auto". Be sure all the sheets are selected when you do this. Then select all the sheets and do your print, or do File - Print, selecting "Entire workbook." -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "forest8" wrote in message ... Currently I have a workbook with 5 worksheets. If I print each worksheet separately, there would be 12 pages in total. I want to have consecutive page numbering on all the sheets so that the page numbering is from 1 to 12 instead of page 1 of 2, page 1 of 3, etc. Is this possible with Excel? Thanks Julie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page numbering of multiple sheets | Excel Discussion (Misc queries) | |||
Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
workbook page numbering | Excel Discussion (Misc queries) | |||
continuous page numbering multiple sheets of a single workbook? | Excel Worksheet Functions | |||
Numbering sheets in workbook | Excel Worksheet Functions |