View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Copy of Header-Footer in Excel

Before entering header/footer, press and hold CTRL key and select the sheets
you want the 'same' header/footer to occur. After selecting all of your
sheets that you will be entering for, then enter your header a
--
John C


"raj74" wrote:

Is it possible to repeat the same "Header-Footer" contents in all the
worksheets (say 5) in a opened file. I am using Excel 2003.
At present, its very boring and time consuming for same "header- footer"
content to copy in each worksheet for display.

Sincerely

Raj