Header and Footer

E

Emece

I want to specify a Header and Footer for all sheets of a workbook. I specify
it in each page, but I have workbooks that have more than 20 sheets, so this
takes me a lot of time.

Is there a way to insert a header and a footer in all sheets of a workbook,
other than manually?

Thanks in advance

Regards,
Emece.-
 
D

David Biddulph

Group the worksheets, then Page Setup.

(Then remember to ungroup the sheets before you do further changes to
individual worksheets.)
 
E

Emece

Hi, Eduardo. Thanks for your prompt reply.

I tried following your instructions, but can't find that option. I am using
Excel 2003. So if I use that option, headers and footers are automatically
printed in all sheets?

Thanks again
 
G

Gord Dibben

Select first sheet then right-click on sheet tab and "Select all sheets"

Add your header/footer to the activesheet and will be done to all.

NOTE: this will change ALL print settings to that of the active sheet except
for settings like Print Area and Rows to Repeat at Top.

Those must be done individually.


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

Top