header footer

C

CW

How do I go about formatting all my worksheets with the same header/footer
without having to do each seperately? I have 25 workbooks with 12 worksheets
each, all I want is for each sheet to have a header image. How can I do this?
 
K

Karthik

Hi CW

Right Click one of the sheets and select "Select All Sheets" form the
pop up menu. Now set your header/ footer. This header/ footer will be
applied to all the worksheets at once.

Thanks
Karthik Bhat
Bangalore
 
C

Christine - HCVT

Keep in mind that after you "SELECT ALL SHEETS", you have to do your page
setup without going into print preview first. Do it from the FILE, PAGE
SETUP toolbar.
 
C

calduke

Christine - HCVT said:
Keep in mind that after you "SELECT ALL SHEETS", you have to do your page
setup without going into print preview first. Do it from the FILE, PAGE
SETUP toolbar.
Click to expand...
 
Top