How can I insert a header only once in excel with many tabs

K

koshur_butteh

I have a file with many tabs and I want to change the footers/headers in each
tab, but I want to make a global search and replace instead of manually going
to each tab. Is there a way to do that?
 
B

Bob Umlas

Select all the sheets (right-click a sheet tab, select All Sheets), use Page
Setup make whatever change you want -- you're doing it to all the sheets.
Then right-click a sheet tab & Ungroup Sheets.
Bob Umlas
Excel MVP
 
K

koshur_butteh

Thank you ... this works great.

Bob Umlas said:
Select all the sheets (right-click a sheet tab, select All Sheets), use Page
Setup make whatever change you want -- you're doing it to all the sheets.
Then right-click a sheet tab & Ungroup Sheets.
Bob Umlas
Excel MVP
Click to expand...
 
Top