View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pixie Gresh
 
Posts: n/a
Default 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