Excel 2007 Page numbering

[Dottie]

Is there a way in 2007 to consectively number all the sheets beginning with
one (1) until ....?

Thank you in advance for your help.

 

[Gord Dibben]

Do you mean consecutive page numbers when printing more than one worksheet?

Select the sheets to print using CTRL + click or Shift + click

Then set up the header or footer with &[Page]

The selected sheets will print consecutively page-numbered.


Gord Dibben MS Excel MVP

 

[Shane Devenshire]

Hi,

If you mean number the sheets from left to right starting with Sheet1, the
answer is yes -
1. Start your workbooks with only 1 sheet
2. Add new sheets by clicking the Insert Worksheet button to the right of
the last sheet tab.

you can of course move the sheets by dragging the sheet tabs. And you can
write a macro to sort the sheets in order.

 

[Dottie]

Thank you, this answered my question.

Do you mean consecutive page numbers when printing more than one worksheet?

Select the sheets to print using CTRL + click or Shift + click

Then set up the header or footer with &[Page]

The selected sheets will print consecutively page-numbered.


Gord Dibben MS Excel MVP

Is there a way in 2007 to consectively number all the sheets beginning with
one (1) until ....?

Thank you in advance for your help.