I'd like to see two things made easier when copying and pasting. The way I
work, I often find myself computing statistics for some data and then wanting
to copy those statistics to a new spreadsheet. The majority of times that I
do this, I'll end up with columns full of #Ref! errors. I'll either have to
then go to Paste Special Values, or I'll want to copy the formulas but
still have them refer to their original cells (not change the cell
references), which means I have to go back to the original formulas and put
in a bunch of $'s. I'd like to see either see right-click options for
these, or some sort of keyboard key that I can hold down in order to let
Excel know.

----------------
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