Chapter 2 Excel Basics34
settings and the number of worksheets in new Excel workbooks. The third category of
popular options can be used to change the language settings.
The options available under the Formulas category can be used to specify how Excel
should carry out calculations. The default setting for calculations is Automatic wherein
Excel automatically updates the calculation result if a value used in the calculation is
modified. You can change the setting to Manual wherein a calculation is performed
only when you press F9 key or click on the Calculate Now command. The Calculate
Now command button is part of the Calculation group of commands that will appear
in the Ribbon when the Formula tab is made active. The Calculation Options button
in the Calculation group of buttons can also be used to modify the calculation mode.
Another option under the Formulas options category is the Formula AutoComplete
option. This option lets Excel show you a list of relevant functions as you type in your
Under the Save options category, you can specify where and how often you want your
workbook to be saved for auto recovery if the application or the computer shuts down
in the middle of your work. The default setting for the auto recovery time is 10 minutes
which is appropriate for most of your work.
The Advanced category has many customization options; some of these options are for
editing, and cut, copy, and paste operations. Through the editing options, you can, for
example, enable editing inside a cell by double-clicking the cell instead of editing the
cell content in the formula bar. In the category of Cut, Copy, and Paste options, you
can change the settings for cut, copy, and paste operations. For example, you can tell
Excel whether the Paste Options menu should appear or not when you paste data into
cells. Some of the options in the Advanced category can be set for the current workbook
The Excel Options window with the Popular options category.