You can copy and insert formulas in the usual way (see Cut or copy the content and Paste the content).

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.Select the Paste Value command in one of the following ways:

On the Edit menu, select Paste Value.

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 Value.

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

Press Ctrl+Alt+V.

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