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
|