changing multiple custom headers at once

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

Guest

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
 
Hi
just select all these sheets before changing the header/footer (hold
down the CTRL key while selecting the sheets)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enter Multiple lines using .leftheader 2
Viewing Headers 7
Macro for Search 6
Change Header on Multiple Sheets without Changing Other Formatting 1
Excel shortcut options 0
different header for different worksheets? 1
Editing Data in Multiple Worksheets/Workbooks 1
Inserting the same header/footer on all worksheets in a workbook 7

Back
Top