Select ALL sheets BEFORE you put in the header. Perhaps most users know
this already, and so there is no NEED to complain.

Pan1 wrote:

Not only do I agree with James, but I must emphasize what a colossal waste of
time this is, typing a custom header on 20 or 30 worksheets for a client.
Ridiculous. This has been a problem for years and just because most users
don't bother complaining, doesn't mean you shouldn't fix it.

"James" wrote:


An option should exist to create a uniform header/footer format across
worksheets in Excel. I shouldn't have to create the same header/format
format across multiple sheets. I should be able to create one header format
and then just change the text/content across the sheets.

This is a big hassle when trying to create print-ready, multiple worksheet
files in Excel that have similar formatting.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc