Last year, I was looking for a tool that could shortcut the "paste as values" command. My requirement fell outside of Excel – I wanted it to paste into WordPress, MS Word, into Google Mail messages etc. I never even thought of using such a tool in Excel.
After a brief search, I found PureText. It is without doubt the neatest piece of software I've installed in the last few years. And it's free.
It's simple. It launches in the background when you start your machine. And the only thing it does is create a shortcut that pastes whatever's sitting on your clipboard as plain text.
So to copy something, you hit CTRL+C in the usual way. But to paste as plain text, instead of hitting CTRL+V, you hit Window+V. (The Window key is present on most non-Mac keyboards, somewhere to the left of the space bar.)
As well as working in the above-mentioned packages, it's also sublime when it comes to Excel. It bypasses the two mouse clicks that you'd usually need to paste values.
If you're a fan of the keyboard shortcut, then this app's just for you.