4 ms·
I just want paste to work as a human might expect. Normal paste in excel ... brings color and font information in, ctrl+shift+v which should just be plain ... d
by mhuffman 3y ago
I just want paste to work as a human might expect. Normal paste in excel ... brings color and font information in, ctrl+shift+v which should just be plain ... does something else? Idk wtf it does, but it paste strings from further back in the history. At least for me on mac
- _v7gu 3y agoNormal paste (paste values) exists but is a bit convoluted: ctrl+v -> ctrl -> v
- qsi 3y agoALT+E, S, V is paste as values. ALT+E, S, T is paste formats. ALT+E, S, F is paste formulas. Those are the ones I use most frequently and these keystrokes are now deeply embedded in my muscle memory. BTW, I would take slight issue with your expectations of what a human might expect... I actually think the standard CTRL+V paste does what 90% of Excel users expect. [Edited to add: this is on Windows, didn't read your comment properly about your experience on a Mac. My apologies.]
- throwaway35705 3y agoThis works until you try have to use Excel localized in languages other than English, since Microsoft thought having localized shortcuts was a good idea.
- mminer237 3y agoNot a solution for Mac, but PowerToys includes an option to make Ctrl+Shift+V plain text paste globally.