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.
Hi, I'm Using Excel v16.45 on a mac and I'm trying to figure out how to set the PASTE shortcut key (command +v) to always match the destination format, automatically.
I. In Mac > System Preferences > Keyboard > Shortcuts I tried creating a mac shortcut key so that "Command + v" is assigned to Pase and Match Style, Didn't work
2. In Mac > System Preferences > Keyboard > Shortcuts I tried creating a mac shortcut key so that "Command + v" is assigned to Pase and Match Formatting, Didn't work.
3. In Excel, I tried customize keyboard > Commands Not in Ribbon > assigning "paste values" with Command + v, didn't work.
4. In Excel, I tried customize keyboard > Commands Not in Ribbon > assigning "paste special" with Command + v, this ALMOST worked. But then the "paste Special" pop-window appears and then I have another step, to click as: text. With this method is there a way to set the paste special to text by default, so I don't have to keep clicking it?
Again, my goal here is to be able to copy text from any other app, such as Google Chrome and paste it into Excel using Command + v and have it match the destination format automatically without other steps. Seems like simple enough of a request. Thanks
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.