View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Skydiver Skydiver is offline
external usenet poster
 
Posts: 40
Default Same Header/Footer-Different Sheets

Good advice. Thanks Mike.

"Mike Rogers" wrote:

Skydiver

A Note of caution: Make sure to "Ungroup" after you get your Header/Footer
chaqnges made. Grouping allows you to make changes to all you worksheets at
the same time, be careful if you do any other editing, what ever changes you
make to one sheet will be reflected on all. This is a nice feature when you
want to make those kind of changes, but can really mess up your work if you
did not what to.

Mike Rogers

"Michael" wrote:

Hi Skydiver. Select the first sheet, hold down the shift key and select the
last sheet. This will group them together. Now add your header/footer and
it will appear on all sheets. HTH
--
Sincerely, Michael Colvin


"Skydiver" wrote:

I have 12 different sheets and would like to use the same header/footer for
each one. I'm having to type the same header/footer for each. Is there an
easier way? Please help. I'm using Microsoft Office 2000 SR-1 Professional.