changing multiple custom headers at once

K

Karl

Hi I would like to be able to make the same change to multiple headers that
are custom in several sheets of the same workbook is this possible? Thanks
Karl
 
F

Frank Kabel

Hi
just select all these sheets before changing the header/footer (hold
down the CTRL key while selecting the sheets)
 
G

Gord Dibben

Karl

Right-click on a sheet tab and "Select all Sheets".

Make your changes to the active sheet under View>Header and Footer and it will
be done to all.

DO NOT FORGET to right-click and "ungroup" after header changes are complete.

Gord Dibben Excel MVP
 
Top