custom header

C

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?
 
G

Gord Dibben

Which version of Excel?

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


Gord Dibben MS Excel MVP
 
G

Gord Dibben

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

Insert>Header and Footer

Click on the Options that you want.

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


Gord
 
Top