As an Excel user, you may want to change how your sheets are calculated. In that case, follow these steps to set calculation options in Microsoft Excel. All instructions and shortcuts are based on Microsoft Excel 2007 or higher for Windows.
Calculation Options in Microsoft Excel
Before following the steps below, make sure you are in an active sheet. Otherwise, start a new sheet (Ctrl-N).
- Display formulas ribbon.
Click Formulas from the menu bar, which should display the formulas ribbon.
- Show calculation options.
Under the formulas ribbon, click Calculation Options, located on the far right of the ribbon.
- Selection a calculation option.
Finally, select either, Automatic, Automatic Except for Data Tables, or Manual.
Now, you know how to set calculation options in Microsoft Excel.
In Excel, press function key 9 (or F9) to calculate a worksheet.
More on Small Shots
Small Shots is a learning system that uses very short, step-by-step instructions and visual aids to accomplish a particular task. Furthermore, with these small tidbits of information and knowledge, your skill set will increase.