How do I set up global headers and footers in Excel?

G

gat3991

Answer: Select multiple tabs with <cntrl> click or <shift> click. Go to
File-->Page Set-up. Select Header/Footer tab. Make desired modifications.
This will apply your headers and footers to all selected sheets. CAUTION: be
sure to select only ONE tab again before editing data, or else you will be
editing data in all selected tabs.
 

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

Project Professional 2016 - Headers and footers not showing up in print preview & printed document 2
Excel 2007, Headers & Footers question 2
Manipulate Headers/Footer in new Sections 0
Find Specific Rows in Range and Create New Tab 18
Macro to Format Multiple Sheets based on "Master" Format 0
Headers and Footers by VBA? 6
Changing headers and footers for Multiple Word Docs 2
Section Breaks and Headers & Footers 2

Top