Numbering sheets

[xzmike]

Hi,

I', trying to number sheets in a workbook (not pages in a sheet). Say I've got a number of sheets.
I've tried this: I select all sheets. On the first sheet I go to Header/Footer & Customize Header and click the page Icon, which puts &[Page] in the header. I go to print preview and I see the number 1. Fine. Then I go to the next sheet and it also has 1 for the page number. I wanted to see 2 printed.

thanks for any help

 

[texasalynn]

you would have to have all sheets selected then go to print preview