Copy of Header-Footer in Excel

[raj74]

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

 

[John C]

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

 

[Dave Peterson]

Lots of print settings can be set if you group the worksheets first.

Select the first worksheet tab. Then ctrl-click on subsequent worksheet tabs.

Then do your page setup stuff.

This may change more than you want, so test the results.

And after you're done, ungroup the worksheets.

Rightclick on one of the selected worksheet tabs and select "ungroup sheets".

Otherwise, you could be making changes to each of the grouped worksheets for
things you don't want!

 

[raj74]

Thanks John & Dave for your reply.

Sincerely

Raj