The main function of excel is to help us make tables to process data. When using excel to calculate data values, we often need to input some formulas. However, due to the daily workload, there will always be problems such as formula typos that cannot be removed. Let's share how to clear these typos. This is a basic operation of Excel, as we all know, and there are many other basic operation tutorials. If you want to learn, you can go. The following is a free self-study video tutorial of Excel. From entry to mastery, help you get started quickly.

Excel clearing formula tutorial:

Method 1:

1. Double-click the single cell where the formula needs to be deleted, and the number in the cell will change to the formula state.

2. Find the function key "F9" on the keyboard and click it to delete the formula in the cell, so as to keep the value obtained by the formula.

Method 2:

1. Let's position the cursor on the result calculated by the formula in the excel table and select it.

2. In the selected state, the formula will be displayed at the top. Then, after you select the calculation result of the formula, right-click the mouse and select Copy or use the shortcut key Ctrl+C to copy the data.

3. After the copy is successful, a circle of dotted lines will be displayed on the outer circle of the table. Place the cursor in the area you just copied, click the right mouse button, and then click Paste Special.

4. Then select a value in the pop-up selection box and click OK.

5. Back in excel, you will find that the pasted value is not in the previous formula format.

The above are two ways to clear formulas in excel, and you have learned both. It should be noted that the second method must be copied successfully, otherwise you will find it impossible to proceed to the next step.