"Gord Dibben" wrote:

Your post is confusing.

Headers and footers options do not number worksheets.

They number printed pages.

To consecutively number printed pages from all 35 worksheets if you're
printing, select all sheets by right-clicking on a tab and "select all
sheets".

Print as one job under "selected sheet(s)".

What is it you want to do exactly?


Gord Dibben Excel MVP

On Wed, 2 Feb 2005 12:31:02 -0800, "itguyintrainin"
wrote:

I am trying to automatically number 35 sheets within the same workbook, using
the header/footer custom option. I am unable to get each tab to see one
another and sucessfully number each tab (sheet) within the workbook. It will
start to number a few, then the formatting will stop. I am running Office XP
SP3, on XP SP2. All help greatly appreciated.



Its not what I want to do but what my boss wants to do. If you were to look
under print prieview, he wants to see page 1 of x in the lower right-hand
corner for each sheet. He wants it to be done automatically and doesn't want
it typed in manually. Printing is not the issue, but inevitably it will show
up on the pages once they are printed. Does that make more sense, or have I
further confused the issue?