Worksheet Headers/Footers

  • Thread starter Thread starter KarinP
  • Start date Start date
K

KarinP

I often have 2 or 3 diff options on estimates. I do this
on separate sheets in the same workbook by copying
estimate 1 and making the changes. How do I get the same
header on all the work sheets without having to retype
every time? Thanks.
 
Karin

One way...when you open a workbook. Select all the sheets (Click on far
left, hold down shift and click far right).

Type the Headers/Footers and the Header/Footer will be the same on each
sheet. Don't forget to un-group. Right click a tab and select un-group.

Anything entered on grouped sheets happens on all those selected.

If you want to select dis-contiguous sheets, click on the tabs while holding
the Ctrl key
 
Back
Top