EXCEL - Headers/Footers

G

GiniC

Select all the tabs for which you want to establish
identical headers (hold down Control while clicking each
tab). Once they're selected, choose File-Page Setup,
create your header, and "OK" your way out of the dialog.
Be sure to UN-select all the sheets (or all subsquent
operations will be duplicated on all sheets) and check the
headers.

I find this very useful when combined with meaningful tab
names - I can put the general information in as text, and
the one portion that differs for each sheet in the tab
name. Then I include the tab name in the header, and the
sheets are all properly named automatically!

Good luck

Gini
 

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
Entering same header & or footer into several worksheets 2
Add footer based on header building block 0
Header and Footer 5
Way to insert a footer in an entire workbook w/o altering headers 2
Header/Footer to update on all sheets 5
Converting excel to PDF, single page converts to multiple HELP! 1
Macro to Format Multiple Sheets based on "Master" Format 0

Top