time_flies

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?

This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

Answer

trip_to_tokyo

F2 key

F9 key

Hit enter

If my comments have helped please Vote As Helpful.

Thanks.

33 people found this reply helpful

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

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

How satisfied are you with this reply?

Thanks for your feedback.

Answer

Jeeped

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 found this reply helpful

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

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

How satisfied are you with this reply?

Thanks for your feedback.

Replies (8)

Last updated January 22, 2021 Views 5,586 Applies to: