How get the same custom footer on all sheets of workbk w/o copy/pa

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

Guest

How do I get the same custom footer on all sheets of the workbk w/o
copy/pasting?
Could I set up a custon footer that could always display on the drop down
list?
 
Laurie

Select first sheet.

Right-click on tab and "select all sheets".

Set up your custom footer on the active worksheet and this set up will be
transferred to all worksheets.

DO NOT FORGET to ungroup sheets when done. What is done to activesheet will be
done to all sheets in the group.


Gord Dibben MS Excel MVP
 

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

How do I copy a custom footer to other sheets 1
Header/Footer to update on all sheets 5
VBA Printing Custom Footer on all but last page 2
How to automate custom footer on all tabs 1
Using same Header & Footer for Multiple Sheets in Excel 3
Change Header on Multiple Sheets without Changing Other Formatting 1
Inserting the same header/footer on all worksheets in a workbook 7
Copying format changes from one sheet to another 4

Back
Top