How to Make Excel 2010 formulas calculate automatically

This tutorial will show you how to make your formulas calculate automatically in Microsoft Excel

The default setting is for formulas to automatically calculate in Excel. This tutorial will show you how to make excel formulas calculate automatically if this setting has become deactivated.

Step # 1 -- Opening a Simple Spreadsheet

Start MS Excel and load a sheet with some information. Here you can see some price information about some simple goods and a total row utilizing the SUM formula. Normally when we change one of the values, the "TOTAL" will change as the SUM formula will update it automatically. Here we can see that this is not happening, even when we change a value to "100".

Step # 2 -- Switching on Automatic Formulas

To enable the automatic calculation of formulas you need to click on the "Formulas" tab in the main menu, from here you need to go to the "Calculation" area and click on the "Calculation Options" icon, in the drop down list click on the "Automatic" option.

Step # 3 -- Seeing the Changes Applied

As formulas will now be calculating automatically you will see the "TOTAL" column automatically adjust to a larger number as the SUM formula takes into account the new figures. From this point on all formulas will calculate on their own and that is how to make excel formulas calculate automatically.

[howtechoffice]

❗ Subscribe To Our Main YouTube Channel

[DrixDrix]

Brief, accurate - and now I know how to run formulas automatically.  What a great voice, and your computer illustration is very slick.  Thanx for the help...

[ChristopherRobinsonKeys]

Thank you. I have no idea how my excel automatic calculation got deactivated, but I was pulling my hair out for 30 minutes before discovering your simple and clear solution video. Cheers!!

[inLuis]

THANK YOU SO MUCH! Helped a lot in my university works! Fast and simple! <3

[HEMAN]

Cracking my Brian... Finally got solution. Thanks a lot brother

[chenwileonardsuh]

GREAT tutorial. thanks a lot. awesome in did, was getting so frustrated on this issue

[joshcollison]

I was so frustrated hitting ENTER for each cell, knowing there had to be an easier way. THANK YOU! Time saving, and easy! :)

[hassanbenabdelali]

Very helpful thanks... tried in vain for several months

[astrixion]

Didn't know Maximillion Pegasus did excel walkthroughs

[abubakarbrimah]

I need help please..say I have a list of 11 items in a column and I have amount set at the bottom. If I want it to read as+1 when I exceed 11 and -1 when my list have 10 items how can I do this

[manoeljohnbeluso]

MY DAD PRESIDENT DONALD TRUMP WILL APPRECIATE THIS VIDEO

[jaderenney]

Mine is on this. I did exactly these steps and its still not automatically doing it! Someone pls help

[christinekreplins]

HI, great clip..problem I am having is that i need for it to do a mixture of cals all the way down the page. This happens but it got to a different box, the cals. EG. 100x 10% =110, then I have 110*10% = 121, then I have 121 * the MOQ and so on and so...can you help me please

[WizardOfCheese]

your voice is very snobby, i dont know if you are putting it on or if you actually sound like that naturally, if so; i apologise for this comment.

[QreQos]

Informative and straightaway method with clear sound and navigation. Keep it up Howtech!!

[johnroberttobis]

What is the electronic spreadsheet program that will automatically calculate simple to complex computations?

[alfredmanaster]

Clean and helpful for manual calculation as well as automatic calculation. Still works in Excel for Mac 2016. Thank you!

[mohammadjoudivand]

Thank you. It was really beneficial for me. Thank you.