Excel 2007 Page numbering

  • Thread starter Thread starter Dottie
  • Start date Start date
D

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.
 
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
 
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.
 
Thank you, this answered my question.

Gord Dibben said:
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.
Click to expand...
Click to expand...
 
Back
Top