James

Try clicking on the first sheet, hold down the shift key and click on the
last... this will set the sheets in [Group] mode. Check this top left by the
file name. Now set the header/footer and it should be set on all selected
sheets. Right click on any selected sheet tab and select Ungroup, as
anything you do with sheets grouped happens on them all.

For interest using the Ctrl key rather than the shift key will select non
contiguous sheets

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"James" wrote in message
...
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