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