Direct Paste Value (Text)
with Excel for Windows there is a Right click past as 'text' option which was super helpful when when building price lists for example where you grabbing data from various sources and wanting to pate unformatted text or pase while not messing with the existing cell formatting. Need a paste as text shortcut or Right click pate text option. Mac does have a default Paste as text shortcut (Shift ALT Apple Key V) but the combo is not friendly,
Right now you have to choose Paste Special, Value which is time consuming if you doing it allot.
With the next update to Excel for Mac (version 16.33 or higher), you will be able to assign a shortcut key and/or add the “paste formatting”, “paste formulas”, and “paste values” actions to your quick-access toolbar (QAT).
For the QAT (under Commands not in the ribbon), the commands are called:
Keyboard Customization (under Commands not in the ribbon), the commands are called:
For the keyboard shortcuts, you’ll need to assign a key combination that isn’t already being used to open the Paste Special dialog.
I don't think there was a builtin shortcut for Paste Values in 2011, but it was easy to add one. In 2019, it doesn't look like it's even possible to add one as Paste Values isn't one of the commands in Customize Keyboard.... Paste Values is probably my most used command so not being able to give it a keyboard shortcut is a big loss.
Danielle Siers commented
Bring back Paste as Values ribbon and keyboard shortcut. These are basic commands that shouldn't require multiple steps to get the required result.
Why do you remove key functionality when releasing new product versions, it's extremely frustrating.
Paste values with "command+shift+v" to paste only values and not the formulas.
Now "command+shift+v" doesn't do anything.
there was a keyboard shortcut for paste value in Excel for mac 2011, its missing in Excel 2016
Larry Nannery commented
When copying cells with values to a different excel file, paste values does not work. Ctrl--cmd--v. Rather it does the annoying paste special
Paste values works within the same excel file, but not to a different.
Drama because Shift ALT Apple Key V doesn't work for me, when attempting to paste text content from the terminal into a cell. I have to keep selecting the edit paste special dialog box and manually picking the Text option. Jeez.
This "Paste special - Values" button is something I really miss. I had to create a small macro in order to have it near and use it through a shortcut and a ribbon button.
Why on earth is this not a feature to be found at least when customizing the Ribbon or the QAT?
Raja Lakshman commented
Hope you all can vote for that.
Richard Widman commented
This is a big pain, especially since you can no longer modify the tool bar to add the paste special button that I had on previous versions. I paste values dozens of times a day.