Shortcut for paste as values
90% of the time I want to past as values, so as to keep the formatting consistent in the location I am pasting. Rather than having to right click then select "paste as values" it would be good to have a shortcut to be able to do this instead.
Paste Special Values is always in the first position on my QAT so I can use Alt 1. It took months before I stopped using Alt H V V. :-)
Wyn Hopkins in https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/34353574-short-cut-key-for-paste-just-value (same idea) pointed out that many keyboards have a "Right-Click" key to the right of the spacebar.
If so, you can press "Right-Click", then V to paste values in a simple keyboard shortcut.
It takes a LOT of effort to overcome habits of the past enough to give it a real try (Alt-E-S-V is very ingrained in me), but once you do... it's a magical, zen-like experience...
"Right-Click", V. Or together like Ctrl-V if old habits are just too hard to break.
Thank you Mr. Hopkins!
In google spreadsheets, they have CTRL+SHIFT+V as the paste values shortcut. It's amazing! I sometimes upload excel to google when i have a lot of paste values to do on an individual basis...
Pls pls add this tiny addition!!
btw, even in excel, u can do a shortened version (in addition to the alt shortcuts), but it doesn't come close to the way google did it:
the second step brings up the little paste pop up near the cell..
But Google's shortcut beats them all!!!
I would love to see this added. Thanks again
Derrick Mickle commented
Keyboard shortcut already exists: Type ALT key (by itself), then E, then S, then V (think "ALT ESV"--it's a bit counter-intuitive but it works ).
WHAT'S GOING ON: Pressing the ALT key by itself brings up the shortcut keys for every item in the ribbon. Note that almost every function in the ribbon has an assigned keyboard shortcut combination. If you have something copied to the clipboard, "ALT,E,S" calls a legacy short-cut key that brings up the Paste Special window. Note the underlined letters in each function in the window.
ALT, E, S, V = Paste [V]alues
ALT, E, S, T = Paste Forma[T] -- faster than Format Painter
ALT, E, S, F = Paste [F]ormulas -- allows you to copy a formula to cells without affecting formatting (super useful)
ALT, E, S, E = Transpos[E] -- transposes columns
I use "ALT, E, S, V" so much that I'd raise holy **** if it went away.
Thomas K commented
Or make an option to set paste only values as standard behavior for ctrl+v
Until such a button gets prioritized onto a ribbon, try this:
Right click on an open grey area of the ribbon, select customize quick access toolbar
Select "all commands" on the left
Find the paste values item (they are in alphabetical order)
click the "Add" button
If needed, move it up or down the list of quick access toolbar items
it should now be in the green bar along the top of Excel, above the ribbon- always available and just a single click :)