Calculate Sheet In Excel 2016

When we work in a Worksheet, Excel automatically recalculates all the formulas when we change the values in the Workbook. However, we have the option to recalculate whatever we want, whenever we want. All you have to do is to continue reading.

First, we must select the Formulas tab and from the end right corner of the ribbon named Calculation we notice the commands available to choose from which are as shown in the image below:

  • Calculation Options
  • Calculate Now
  • Calculate Sheet

Calculation Options

If we select the Calculation Options command, the drop down menu will appear where we can choose from the following:

Automatic: All the calculations in the spreadsheet will be done automatically.

Automatic Excepts For Data Tables: All the calculations except for Data Tables in our spreadsheet will be done automatically.

Manual: If we have chosen the Manual command, in order for us to do the calculation in a Formula we must select the Calculate Now command. In order for us to do the calculations in our spreadsheet we must select the Calculate Sheet command.

Calculation Options Drop Down List

All we have to do is to click on one of the commands from the Calculation Options drop down menu, and the tick mark will be moved to the left of the command we selected.

Another way in order for us to adjust how our spreadsheet will be calculated is to select the File tab in order to move to backstage view, and from the drop down menu to select the category Options from the left as shown in the image below.

Backstage View - Options

Once the category Options is selected the Excel Options dialog box appears where we select the category Formula from the left. Then from the middle of the dialog at the top we notice the area named Calculation Options as we can see below.

Under this area we have the Workbook Calculation area which is separated from the following commands:

  • Automatic
  • Automatic Except For Data Tables
  • Manual

The commands are the same as the ones that we select from the Calculations area of the Formulas tab and their use is also the same.

Below you can check out the video describing the Calculation Options in an Excel Workbook.


About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on June 14, 2016, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Calculate Sheet In Excel 2016.

Comments are closed.