Paste as Values only

Hi Sabina

I don't know of a direct shortcut but the following steps are still quicker than the menus

The steps to only paste values in Excel follow below:
Select the cell(s) with formulas and press Ctrl + C to copy them.
Select the destination range. ...
Press Excel's paste values shortcut: Ctrl + Alt + V, then V. (This displays the Paste Special dialog box)
Press Enter.

Alternatively, when you paste a paste options flag appears and can choose how to paste your data.

Create your own macro?

I've searched and there doesn't seem to be a way to set it perm to Values.

Let me know how you get on with the above.

Kind regards

Dennis