While working in **Excel**, you may have trouble using formulas. To get rid of this problem, you need to know **how to Fix Formulas in Excel**. In this article, I am going to show how you can** Fix Formula in Excel**. Here, I will prescribe 9 quick tricks to **Fix Formula in Excel** with the necessary steps and illustrations.

**Table of Contents**hide

## Download Practice Workbook

Please download the practice workbook to practice yourself.

## 9 Effective Ways to Fix Formula in Excel

Let’s take a dataset of** Daily Sales of ABC Shop**. The dataset consists of 2 columns. Columns** B **&** C** are indicating **Day **and** Sales** respectively. We have 8 rows of data also. To **Fix Formula in Excel**, we are going to use **Fixing Calculation Option, Changing Cell Format, Removing Space before Equal, Turning On Show Formula, Recalculation of Formula, Background Error Checking, Tracing the Error, **etc. Hope these procedures will help you to use Excel efficiently.

### 1. Fix Calculation Option to Fix Formula in Excel

In this section, I am going to describe a method to** Fix Formula in Excel**. It is a very easy method. Here I am going to **Fix Formulas in Excel** by **Fixing Calculation Option**. Hope this will help you to fix problems regarding formulas.

**Steps:**

- First,
**Go to**the**Formulas**option from**Toolbar**. - Then
**Select**the**Calculation**option on the**Ribbon**.**Click**on it. - You will find the
**Manual**option is selected.

- Select the
**Automatic**Your problem regarding formulas will be solved.

**Read More: [Fixed!] Excel Links Not Working Unless Source Workbook Is Open**

### 2. Change Cell Format to Fix Formula in Excel

In this section, I will describe another method to** Fix Formula in Excel**. Here I am going to **Fix Formulas** by **Changing Cell Format** with necessary illustrations.

**Steps:**

- Firstly,
**Select**the**Home**tab on the**Toolbar**. - Then, you will find the
**Number**Option there.**Click**on it. - After that, you will see that the value in
**B5**cell is in**Text Format**.

- Now,
**Click**on the**Dropdown Menu**to change the**Text Format**. - Then,
**Select**the**General**Your problems regarding formulas will be solved then.

**Read More: How to Show Menu Bar in Excel (2 Common Cases)**

### 3. Remove Space Before Equal Sign for Fixing Formula

In this section, I am going to describe another easy and handy process to Fix Formulas in excel. It will require only a few seconds to Fix Formula. The problem shown in this section happens only when you keep a space before the equal sign of the formula. Here is the solution to solve this problem and to Fix Formula.

**Steps:**

- You can see a space is entered before the equal sign of the formula. As a result, the formula is not working.

**Delete**the**Space**before the equal sign of the formula.- Hence,
**Press Enter**. Your problem will be solved by this way.

### 4. Fix Formula by Turning On Show Formula Button

I will describe a short method here. This will help you to **Fix Formula in Excel** within a second. I am going to **Fix Formula in Excel** by **Turning on Show Formula Button**. Here are the steps of the method with necessary figures given below.

**Steps:**

- First,
**Go to**the**Formula.** - Then
**Select**the**Formula Auditing.** - After that,
**Select**the**Show Formula.** - At Last, you will find the formula shown in the
**C12.**

**Read More: [Fixed!] CTRL C Not Working in Excel**

### 5. Perform Recalculation to Fix Formula

In this section, I am going to show how to **Fix Formula in Excel** with a quick trick. It is a very handy tool. I am going to **Perform Recalculation** to **Fix Formula in Excel**. I will describe the whole method with necessary steps and images.

**Steps:**

- To
**Perform Recalculation**of Formula, at the very first step,**Go to****Formulas**tab on the**Toolbar**. - You will find the
**Calculate Now**option just like indicated in the next picture.**Click**on it. - Excel will recalculate your formula.
- As a result, you will get a solution to your problem.

**Read More: How to Calculate Cost of Funds in Excel (with Easy Steps)**

**Similar Readings**

**How to Remove Last Modified By in Excel (3 Ways)****If a Value Lies Between Two Numbers Then Return Expected Output in Excel****How to Create Butterfly Chart in Excel (2 Easy Methods)**

### 6. Enable Background Error Checking to Fix Formulas in Excel

In this section, I will** Enable Background Error Checking** to **Fix Formulas in Excel**. It is a smart way to **Fix Formulas in Excel**. I will describe the method step by step. I hope all my steps and illustrations will help you to Fix Formulas in Excel.

**Steps:**

- Firstly,
**Go to**the**File**option of your**Excel Toolbar**.

- Then you will find the menu bar just like the picture shown below. From there,
**Select**the**Options.**

- After that, you will find the
**Formulas**option there.**Click**on it. - Then,
**Select**the**Enable Background Error Checking.** **Excel**will check if there is any kind of background error not.- Your formula will be fixed then.

### 7. Use Evaluate Formula Tool to Fix Formulas in Excel

In this method, I will **Evaluate Formula Tool** to **Fix Formulas**. This is another reliable method to** Fix Formulas in Excel**. I will describe the method step by step with necessary illustrations.

**Steps:**

- First,
**Select**the**C12.** **Select**the**Formula.**- Then,
**Select**the**Formula Auditing.** - After that, you will find the
**Evaluate Formula****Click**on it.

- You will find the window just like the one given below.
- You will see the function here.
**Click**on the**Evaluate**

- As a result, you will find the evaluated result in the window.
**Click**on the**Close**By doing this, your formula evaluation is done.

**Read More: How to Use Excel Formula Not to Exceed a Certain Value**

### 8. Fix Formula by Tracing the Error

In this section, I am going to **Fix Formula **in **Excel **by **Tracing Error**. This method is handier than other methods as you will trace the cell where an error occurred. I am considering a new Dataset here having 4 columns **B**, **C**, **D, **and **E **indicating **Day**, **Cost**, **no**. **of Workers **& **Cost per Workers**. I am going to describe the whole process step by step with sufficient figures to **Fix Formula in Excel**.

Here, we can see an error in **E6 **cell.

**Steps:**

- First,
**Select**the**E6** - Then,
**Go to**the**Formula** - After that,
**Select Formula Auditing** - You will find the
**Error Checking**option there.**Click**on it. - Moreover, you will find the
**Trace Error**option there.**Select**it.

- Hence, excel will show you the trace of error with an arrow just like the picture given below.

- To remove the arrow,
**Select**the**Remove Arrow**under**Formula Auditing.**

**Read More: How to Move Data from Row to Column in Excel (4 Easy Ways)**

### 9. Use Get Help Option to Fix Formula in Excel

In this part of this article, I am going to describe the last but not the least method to** Fix Formula in Excel**. This is another simple process. Here, you can find an error in **E6 **cell. I am going to **Fix Formula** by using the** Get Help** option. Here, I will describe the steps of the method with basic illustrations.

**Steps:**

- First,
**Select**the**E6** - Then,
**Go to**the**Icon**Indicated in the next picture.

- You will find a
**Dropdown****Select**the**Help on This Error**option.

- After selecting the option, you will get a window just like given below at the right side of your Excel workbook. In this window, Excel will indicate the error. Excel will also give a solution of the error.

**Read More: How to Move Up and Down in Excel (5 Easy Methods)**

## Things to Remember

- To trace the error, you need to select the cell where the error occurred.
- You need to select the cell where formula is input to use the evaluate formula tool.

## Conclusion

I hope these nine methods will help you to handle the Excel problems by **Fixing Formula **in **Excel**. I think you will find interest in these methods. If you have any kind of queries, feel free to ask me in the comment section.

## Related Articles

**Create an Organizational Chart in Excel from a List****How to Calculate Root Mean Square Error in Excel****Descriptive Statistics – Input Range Contains Non-Numeric Data****How to Do Descriptive Statistics in Excel (2 Suitable Methods)****Make Trial Balance in Excel (with Easy Steps)****How to Get Summary Statistics in Excel (7 Easy Methods)****Make Fishbone Diagram in Excel (with Easy Steps)**