Allow header/footer to copy to other worksheets in 1 spreadsheet.
 

I have a spreadsheet with 54 worksheets (by hospitals). It takes 72+ strokes
to setup each worksheet separately. It would be so much easier to have the
ability to highlight/ctrl-c/ctrl-v. To make this a perfect upgrade, it would
be nice to have a prompt to click that we want the header and footer format
on all worksheets, then have the ability to go in and change certain things
specific to that worksheet.

When you get to the footer, if you have to information in all 3 boxes, you
have to type in the data (or shortcuts) in each square...then to change the
font, you have to highlight one box at a time, click the format key, then
click the next box and repeat.

You guys are probably thinking there is another product (Access) out there
that makes all of this no longer necessary...but there are fewer than 5
people in this organization that knows how to do anything on a computer.

----------------
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...et.f unctions

Allow header/footer to copy to other worksheets in 1 spreadsheet.
 

Pixie, try grouping your worksheets first if you want to put the same header
or footer on all of them at once.

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Pixie Gresh" <Pixie wrote in message
...
I have a spreadsheet with 54 worksheets (by hospitals). It takes 72+
strokes
to setup each worksheet separately. It would be so much easier to have the
ability to highlight/ctrl-c/ctrl-v. To make this a perfect upgrade, it
would
be nice to have a prompt to click that we want the header and footer
format
on all worksheets, then have the ability to go in and change certain
things
specific to that worksheet.

When you get to the footer, if you have to information in all 3 boxes, you
have to type in the data (or shortcuts) in each square...then to change
the
font, you have to highlight one box at a time, click the format key, then
click the next box and repeat.

You guys are probably thinking there is another product (Access) out there
that makes all of this no longer necessary...but there are fewer than 5
people in this organization that knows how to do anything on a computer.

----------------
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...et.f unctions