There are lots of ways to skin that cat though they all boil down to doing a Paste Special of a sort...
* If you right-click on your destination cell, a context menu will appear with commonly used paste special options. You should use the one that looks like a clipboard with "123" on it, Values Only.
* Using only the keyboard, you can press CNTL-ALT-V, then V, and then Enter which is nice if you're a contortionist. A slightly less cumbersome keyboard method is Alt-H-V-V. I don't think there's a way to modify keyboard shortcuts as you can in Word which, not knowing the developers' minds on the matter, seems pretty lame.
* You can add a Quick Access Tollbar button for Paste Values.
* You can create a macro in your normal template (or the sheet you use if it's generally the same one) and assign whatever keyboard shortcut you want.
Personally, I use Paste Special all the time and I always use the first method.
|