Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need to make page numbers sequential across worksheets
Hi,
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need to make page numbers sequential across worksheets
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. |
#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. . |
Reply |
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) |