header footer
 

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.

"Karthik" wrote:

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

header footer
 

"Christine - HCVT" wrote:

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.

"Karthik" wrote:

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