Today, we are going to show how to turn on auto-calculate in Excel. When the auto calculate is turned on, Excel considers the changes made to a particular dataset and then adjusts the result of any formula associated with that dataset. This makes calculation in Excel easier. Without a functioning auto-calculate feature, users have to calculate manually after any change to the dataset is made. This is a very tedious task in the case of a large dataset.
How to Turn on Auto Calculate in Excel: 2 Handy Ways
In this article, we will discuss 2 methods to turn on auto calculate feature in Excel. Here, we have a dataset that contains the revenue values for different products and their total which we calculated by using the SUM function. We will change the revenue value of any product and will evaluate the effect on the total which is currently $38100 before and after turning on the auto calculation.
1. Using Excel Options
In this method, we will use the Excel Options to turn on the auto calculate feature in Excel. This method allows users to change the settings of the entire workbook by going to Excel Options.
Steps:
- To begin with, choose the C8 cell and change the revenue for the Tab from $5000 to $4000.
- However, you will see no change to the Total.
- Now, go to the File tab first.
- Next, select Options.
- After that, click on Formulas.
- Then, choose Automatic from the Workbook Calculation section.
- Finally, click on OK.
- As a result, the auto calculation will be activated, and the new Total will be recalculated to be $37100.
This is how we will turn on the auto calculate feature using the Excel Options.
Read More: How to Make Excel Auto Calculate Formulas
2. Utilizing Calculation Options
Here, we will utilize the Calculations Options to do the job. This will allow users to turn on the feature quickly.
Steps:
- At the start, make some tweaks in the dataset by changing the revenue of the Tab from $5000 to $4000.
- But we will see no change in the Total revenue.
- Now, first go to the Formulas tab.
- Secondly, click on the Calculation Options ribbon from the Calculation group.
- Finally, from the drop-down options choose Automatic.
- As a result, Excel will auto calculate the new Total to be $37,100.
Thus, we will get the right result by turning on the auto calculate feature by utilizing the Calculation Options.
Download Practice Workbook
You can download the practice workbook here.
Conclusion
In this article, we have talked about how to turn on auto calculate in Excel. This will make the life of an Excel user easier by making calculations automatic. If you have any questions regarding this essay, feel free to let us know in the comments.
Related Articles
<<Go Back to Excel Auto Calculate | How to Calculate in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
