This is undoubtedly one of the most often used features in Excel. Normally when you copy a cell that contains a formula, the formula is pasted as well, which is handy.

But if you want to copy only the result, without the formula, choose Edit, Paste Special. The Paste Special dialog box appears. Among many other things, you can choose Paste Special to extract the results of formulas. To transfer only the resulting values of formulas, select the Values option.