Excel 2007

B

Brachy

Is it possible to copy Header and Footer data across all sheets in a
multi-page Workbook.
If not, why not?
 
J

Jacob Skaria

You can. Right click the sheet tab>Select all sheets> and then set header and
footer which will be applied for all sheets

If this post helps click Yes
 
G

Gord Dibben

Be careful with this.

It will also change most print settings on all sheets to that of the
activesheet.


Gord Dibben MS Excel MVP
 

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

Header and Footer 5
different header for different worksheets? 1
Insert Page Numbers on Worksheet in Excel 2007 6
Header/Footer to update on all sheets 5
CREATING HEADERS AND FOOTERS 3
HOW DO I DUPLICATE ONE SHEET MULTIPLE TIMES 3
Change Header & Footer Info w/ Worksheet Option Buttons 1
Excel startup 5

Top