Footer in Excel

G

Guest

How do you copy a footer from one worksheet to another. I don't want to have
to re-type the footer on each page.
 
D

Dave Peterson

Group the sheets you want to have the same footer.
click on the first worksheet tab.
ctrl-click on the subsequent.

Change the footer

Ungroup the sheets (rightclick on any and choose ungroup sheets)
 

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

Excel Unique last page footer 1
how do i make a footer on second page only? 2
tab names are wrong when printing custom footers (using [&tab] ) 1
numbering pages in footer 1
Arrange Footer 2
Header and Footer 1
Change date format in Excel footer 2
PUT PAGE NUMBER INTO A SPECIFIC CEL? 1

Top