If necessary, you can copy a formula from one cell and paste the final value of the formula into another cell without the formula itself. To do this, follow the steps below:

1.Copy a formula in the usual way.

2.Select a cell where you want to enter the resulting value of the formula.

3.To insert the result of a formula calculation without the original formatting, do one of the following:

On the Edit menu, select Paste Values Only.

On the Toolbar, select the Edit section and click the arrow to the right of the t_edit_paste Paste button. In the drop-down list, select Paste Values Only.

Open the context menu of the cell by right-clicking it and select Paste Values Only.

4.To insert the result of a formula calculation with the original formatting intact, do one of the following:

On the Edit menu, select Paste Values and Format.

On the Toolbar, select the Edit section and click the arrow to the right of the t_edit_paste Paste button. In the drop-down list, select Paste Values and Format.

Open the context menu of the cell by right-clicking it and select Paste Values and Format.

Press Ctrl+Alt+V.

 

Was the material useful?
Yes
No
Users found this material useful: 0 из 0