header footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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.
 
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...
 
Back
Top