How do I set default footer setting on excel spreadsheets?

G

Guest

I have an Excel spreadsheet with 10+ tabs (separate sheets) that all need to
have the same footer format. How do I either cut & paste (I haven't been
able to do this) or set it as a default in the drop down menu? I need the
same thing in the left, center, and right sections of the footer with the tab
name being the only difference.
 
D

David Biddulph

Madison1216 said:
I have an Excel spreadsheet with 10+ tabs (separate sheets) that all need
to
have the same footer format. How do I either cut & paste (I haven't been
able to do this) or set it as a default in the drop down menu? I need the
same thing in the left, center, and right sections of the footer with the
tab
name being the only difference.
Click to expand...

Select all the sheets, then set up 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

how do i default a footer in all the excel files i open 1
Default page 1
how do i make a footer on second page only? 2
Set a header/footer as default 1
Excel footer default font size 1
Vertical footer placement 1
How do I change the default header date format in Excel 2007? 3
How can I using Excel custom document properties in the header? 4

Top