Add an option to change the default for "Paste" so that it can be "Formulas" or Values"
The default for the Paste button is Paste All. This instantly destroys conditional formatting, other formats, and bordering of regions. There are now a good selection of Paste options below the Paste Button and the ability to select any one of these as the "Current Default" would speed up development time considerably. The Paste button image could be changed to show the current default.
The important ones are to have are "Paste Formulas" and "Paste Values". The best (and simpler) implementation, in my opinion, would be to have the Paste button do Paste Formulas with the button image changed to show this and include a "Paste All" option on the button drop down (probably a step too far but I can hope).
It is possible (or at least was) to add an icon that invokes Paste Values. Does that provide similar functionality? Could we get a real keyboard shortcut for Paste Values and Paste Functions? Not ones with extra steps required. A keyboard shortcut that brings up the Paste Special dialog box is virtually worthless.
Andrew Amatasoasei commented
Wouldn't this suggestion help your cause too? What they ask for is already implemented in Word and OneNote so it would seem more likely to also be implemented in Excel. More votes in one place.
M clark commented
There was a version of excel that when you pasted a list would sold show. If you wanted to paste values you pressed v and it did it. no more steps. That version may be 97 but it only lasted a short time and I loved that ability. I think it was a right click but it was very efficient.