TL;DR: Press F2
, then F9
to replace a cell by its value.
Click on the formula cell (click once, no need to click twice):
Now press the F2
key to edit the cell:
Now press the F9
key to replace the cell by its value:
TL;DR: Press F2
, then F9
to replace a cell by its value.
Click on the formula cell (click once, no need to click twice):
Now press the F2
key to edit the cell:
Now press the F9
key to replace the cell by its value:
If this post helped you, please consider buying me a coffee or donating via PayPal to support research & publishing of new posts on TechOverflow