shortcut key for paste option

Hi,

When cut and paste, in order to select a paste option, such as 'value only', I have to click open the paste optin icon to select the option. Is there a key to activate the paste option icon without the mouse click? Is there a shortcut key series to direct select 'value only', 'link cell', etc.?

Thanks!

Good morning Michellekong

To answer your question, no, there isn't.

If you are using a mouse at the minute you can use a series of shortcut keys, which would speed things up.

For example to paste values only, once you have copied, use:

alt+e+s (opens paste special dialog)
v will check the special function
Enter to accept

Or you could set up a macro and store it in a button to call whenever you need it.

HTH

DominicB

Thank you! It helps.

Good. Glad you found it helpful. And thank you for the feedback. it's always appreciated.