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.

Thanks for answering gebobs. Yes, I shall have to use the first method in your list until such time as my memory returns, if it does. But as I said in the OP

'I once found the correct setting years ago, and it worked pefectly for a long time...' and 'I used to know how to do this so I know it is possible. Seems like it was somewhere in File/Options, I just can't find it.' and 'I (like to) use the <Ctrl-C>+<Ctrl-V> method as it is, to me, both quicker and more elegant. I know that were I to left-click in the cell, I would get the pasting options but for my needs that is too cumbersome and time-consuming.'

But it is my faulty memory and I will have to live with it...still, again thanks for taking time to answer.