| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need to make page numbers sequential across worksheets
Perfect!! Exactly what I needed. Thank you.
"Ed Ferrero" wrote: Hi Kate, Group the sheets before printing them. i.e. click on the first sheet tab, hold the Shift key down, click on the last sheet tab, then go to Print Preview - the page numbering is now consecutive. Ed Ferrero www.edferrero.com I have a workbook with 3 worksheets (and page # footers on each of them) in Excel 2003. When I print the entire workbook (4 pages per worksheet x 3 worksheets = 12 pages). each worksheet starts with "page 1". The page number order goes: 1,2,3,4,1,2,3,4,1,2,3,4. How do I change it so that the page numbers are listed as 1-12? I don't want to list each manually as the data changes regularly, leading to different page numbers Thanks for the help. . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| new page opened with sequential numbers from last saved | Excel Worksheet Functions | |||
| Make sequential numbers each time sheet is opened | Excel Worksheet Functions | |||
| Print sequential page numbers on one worksheet printed multiple ti | Excel Worksheet Functions | |||
| print multiple copies of the same page with sequential numbers | Excel Discussion (Misc queries) | |||
| How can i print sequential page numbers 1 to 10, if i have one wo. | Excel Discussion (Misc queries) | |||
Threaded Mode
