Thanks John & Dave for your reply.

Sincerely

Raj

"Dave Peterson" wrote:

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 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

--

Dave Peterson