L
linda
Is there a way to get page numbers in a workbook to run
consecutively from one sheet to the next?
consecutively from one sheet to the next?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PegL
If you select multiple sheets, then print, Excel will
consecutively # the pages.
consecutively # the pages.
M
Melinda
If I understand correctly, you can do this in the
header/footer . You can insert the function and it will
automatically number your pages.
header/footer . You can insert the function and it will
automatically number your pages.
D
David McRitchie
I think there is a misunderstanding of the word sheet,
I think the poster is referring to several worksheets,.
Page numbers don't really come into play until you print.
This is confusing enough in English, and probably much more
confusing when translated into other languages.
If you print a single worksheet at a time you get page numbers running
through the each worksheet as you select and print them.
If you group your sheets as the
other responders suggest then you can print the grouped sheets
all at one time and the page numbers will run through the
entire group of sheets. Unfortunately Excel does not allow you
do both at the same times. You can't say page 1 of sheet2, page 7 of 22 total pages.
To group sheets, use the Ctrl key and select additional sheets.
Warning of Danger with Grouped Sheets:
When you are finished printing it is imperative to ungroup the sheets
or risk serious damage to the pages you do not see in the group,
as any change made to the visible sheet in the group is made to
al of the sheets in the group.
To ungroup your sheets, Right click on any sheet tab and
choose "ungroup sheets". Another way is to select a single
sheet outside of the group. There are other ways but be careful.
I think the poster is referring to several worksheets,.
Page numbers don't really come into play until you print.
This is confusing enough in English, and probably much more
confusing when translated into other languages.
If you print a single worksheet at a time you get page numbers running
through the each worksheet as you select and print them.
If you group your sheets as the
other responders suggest then you can print the grouped sheets
all at one time and the page numbers will run through the
entire group of sheets. Unfortunately Excel does not allow you
do both at the same times. You can't say page 1 of sheet2, page 7 of 22 total pages.
To group sheets, use the Ctrl key and select additional sheets.
Warning of Danger with Grouped Sheets:
When you are finished printing it is imperative to ungroup the sheets
or risk serious damage to the pages you do not see in the group,
as any change made to the visible sheet in the group is made to
al of the sheets in the group.
To ungroup your sheets, Right click on any sheet tab and
choose "ungroup sheets". Another way is to select a single
sheet outside of the group. There are other ways but be careful.
J
Jay
linda said:Is there a way to get page numbers in a workbook to run
consecutively from one sheet to the next?
For each sheet, use:
File >> Page setup >> Page
and set "First page number" to "Auto"
(Works for me with Office 97.)