Convert cell formula to value - short cut key

Is there a shortcut key to convert a cell to value instead of going through the copy/paste special routine?
 

Question Info

Last updated October 10, 2019 Views 5,480 Applies to:
Answer
Answer

F2 key

F9 key

Hit enter

If my comments have helped please Vote As Helpful.

Thanks.

32 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Answer
Answer
Record a macro using CTR+C, ALT+E,S,V <enter> <esc> using relative referencing and assign it to a keystroke conbination.
  • "Have you tried turning it off and then on again?" - Roy from 'The IT Crowd' (Emmy award-winning British comedy)

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.