How do I copy footer setup from one tap to many tabs?

G

Guest

I have a very specific footer setup on one tab of a worksheet. I would like
to copy that footer setup to other tabs (more than 30) without having to
reenter it on each worksheet. Can it be done?
 
T

Tom Ogilvy

make you special sheet the first in the tab order of all 30 sheets.

Select the special sheet. Hold down the shift key and select the 30th
sheet.

View = Header and Footer

then select your footer and click OK

right click on the sheet tab and select ungroup sheets and all sheets should
have the footer
 

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

Change Header on Multiple Sheets without Changing Other Formatting 1
copy footer without copying page setup 2
How do I make a single header/footer common across all worksheets? 1
How do I copy a custom footer to other sheets 1
Page Setup 2
Page setup for multiple worksheets 1
How to automate custom footer on all tabs 1
Copy of Header-Footer in Excel 3

Top