Page numbering

[Guest]

How do I sequentially number all of the worksheet pages in a workbook?

 

[Guest]

I think this is what you are looking for..

Set the header or footer (in each worksheet) to print the page number. Then
when you print, select "Entire Workbook" on the Print dialog.

 

[Jim Rech]

There is no built in way to do this. So your options are to do it manually
or by a macro such as this:

Sub NumberSheets()
Dim Counter As Integer
Dim Sht As Worksheet
For Each Sht In Worksheets
Counter = Counter + 1
Sht.Name = Counter
Next
End Sub

 

[Dave Peterson]

If you select all the worksheets in your workbook (rightclick on one worksheet
tab and choose Select All Sheets), then do your file|print (or print Preview
until you're happy), does it work?

You can even set the footer on all sheets when you have the worksheets grouped.

(Make sure you ungroup the worksheets when you're done.)

==
Or you could do
file|print
Print what: check "entire workbook"

Both seemed to work ok for me.

 

[Jay]

If you select all the worksheets in your workbook ...

Or you could do
file|print
Print what: check "entire workbook"

And in addition, look at
File >> Page setup >> Page
for each sheet, and make sure "First page number" says "Auto" (without the
quotes).