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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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...
 
Back
Top