custom header

[ct_pws_3]

Is it possible to link my custom header to the name tab on my work sheet? If
my tab name is March 2009, I don't want to re type this in my print header.
Also can these tabs be automated for example insert current date?

 

[Gord Dibben]

Which version of Excel?

2002 and newer have that functionality when setting up Custom Headers or
Footers.


Gord Dibben MS Excel MVP

 

[ct_pws_3]

Thank you for responding, I have the latestest version of excel/ vista

 

[Gord Dibben]

On Ribbon...................

Insert>Header and Footer

Click on the Options that you want.

Date.....Time........Sheet Name etc.


Gord