Select a cell containing a formula and press F2 to edit and then F9 to calculate.



Press Ctrl+Shift+".



Copy a range of cells containing formulas, select Home -> Paste arrow symbol (In Clipboard Group)
-> Paste Values.
Or
Right click, and select Paste Special -> Values.



1. Select a range of cells containing formulas.
2. With the mouse cursor over the selection border, drag the range while holding down the right button.
3. Release the mouse button and select Copy Here As Values Only from the shortcut menu.