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