Copy of Header-Footer in Excel

R

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
 
J

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
 
D

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Automatically insert "Continued" in footer based on existing STYLEREF 2
Add footer based on header building block 0
How do I make a single header/footer common across all worksheets? 2
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Embedded Excel into Word with Tables 0
Viewing header/footer in Excel very slow 1
Lost header and footer view in 0

Top