how to set up same header and footer on each worksheet

L

Liana

i can't find a way to set up a header footer which will stop me having to
type up one on each individual sheet have tried office help and asking
colleagues - help


I want to be able to put my name/date and workheet ref on each individual
worksheet (I know how to do for one sheet but want to apply to all)
Using exel 2003
 
Y

Youppie

Hi Liana,

select all sheets you want to have the same header or footer (select the
first one and, while keeping Ctrl pressed, click on the tab of each other
sheet, you want to include - you can also use Shift for ranges, as usual...)
go to page setup on the file menu
move to the header/footer tab
enter your header or footer respectively and they will appear on all
selected sheets...

Youppie
 
Top