An even better solution is to select all tabs using control key (or shift key
if you select first sheet then hold down shift and select last tab, that will
open all sheets) then go to View menu and select Header and Footer and then
set up your header or footer. The same header and footer will then appear in
all worksheets and the page numbering if you have set this up will run
through all work sheets.

Don't forget to ungroup the sheets afterwards - Right click on a sheet
tab.

Pete

On Jan 23, 9:12*am, Piusx3 wrote:
An even better solution is to select all tabs using control key (or shift key
if you select first sheet then hold down shift and select last tab, that will
open all sheets) then go to View menu and select Header and Footer and then
set up your header or footer. The same header and footer will then appear in
all worksheets and the page numbering if you have set this up will run
through all work sheets.

Better than what?


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 01:12:01 -0800, Piusx3
wrote:

even better solution