Excel makes it possible to perform various calculations, including analytical ones. The program allows you to create your own formulas or use built-in functions. But often it is necessary to keep the final result in a "stable" form. Or you simply do not want the other user to see the formulas used for the calculations. In these cases, use storing as values.
Instructions
Step 1
If you need to remove a formula in one specific cell, place the mouse cursor on it and press the left key. The function bar (immediately below the toolbars) will display the formula used to calculate the value in the cell.
Step 2
Press the right mouse button. A context menu will appear. Activate the item "Copy" in it, a dotted frame should appear around the cell. Right click again. In the list that appears again, select the "Paste Special" line. A new window will open with insertion options. With the left mouse button, mark the item "values" or "values and formats of numbers". Then click the "OK" button. You will see that the result number appears in the function bar instead of the formula.
Step 3
You can change formulas to values in several cells at once. To do this, you first need to select these cells, and then repeat the steps described in step 2.
Step 4
In order to change formulas to values in an entire row or column, you must first select the entire corresponding area. To do this, move the cursor to the upper border of the sheet with the names (letters) of the columns or the left border with the row numbers and set it at the required level so that the cursor turns into a black arrow. Then press the left mouse button and you will see that the entire row (column) is highlighted. Follow the algorithm from clause 2 of this instruction.
Step 5
If you want to save all calculations on the worksheet as values, move the cursor to the upper left corner of the worksheet. When you see how the corner square is highlighted, press the left mouse button. This will select the entire work area. Repeat the sequence of actions from step 2.
