Shortcut Keys

[Margin King]

Can anyone tell me if there is a ShortCut key to paste only the value of a cell. eg Ctrl-C to Copy followed by Ctrl-V to paste both the value and the format of the cell. At the moment I'm using Ctrl-C as normal then going to the destination cell and using right click and selecting Paste Options 123 for just the value. Id there a Ctrl-? shortcut for this?
Thanks all

 

[FormR]

Hi, I don't think there is a direct short-cut key, but I use:

CTRL+ALT+V then (or ALT+V) then ENTER

 

[RoryA]

Depending on your release of 365, you can try Ctrl+Shift+V

If not, use Ctrl+Alt+V to get the paste special dialog, then V and enter. (Alt+ESV for older)

 

[Fluff]

I use the context menu key followed by v. It's the key with a little box with 3 lines inside to the right of the space bar.

 

[Sufiyan97]

Another one is to Past with Ctrl + V and then again press Ctrl then V.