For example, the ToolTip in Figure 3.6 shows information about the calculation settings. It also provides some tips about what you need to be aware of when you turn on the setting. The ToolTip explains what happens when you choose the setting.

If you hover the mouse near this icon, Excel displays a super ToolTip for the setting. Many settings appear with a small i icon. Links to the Microsoft Trust Center, with 12 additional categories. New add-ins can be installed from the button at the bottom of this category. Icons to customize the Quick Access Toolbar (QAT).Ī list of available and installed add-ins. The default method for saving, AutoRecovery settings, legacy colors, and web server options.Ĭhoose the editing language, ToolTip language, and Help language.Īll options that Microsoft considers arcane, spread among 13 headings. Spell-check options and a link to the AutoCorrect dialog. Note that options for multithreaded calculations are currently considered obscure enough to be on the Advanced tab rather than on the Formulas tab. The most commonly used settings, such as user interface settings, default font for new workbooks, number of sheets in a new workbook, customer name, and Start screen.Īll options for controlling calculation, error-checking rules, and formula settings. Table 3.1 gives you a top-level view of where to start looking for settings. Beyond those 15 settings, though, are hundreds of settings spread throughout 21 categories in the Excel Options and Trust Center. To the Excel team’s credit, they tried to move the top options to the General category. The Trust Center leads to another 12 categories.

The dialog has categories for General, Formulas, Proofing, Save, Language, Advanced, Customize Ribbon, Quick Access Toolbar, Add-Ins, and Trust Center. Open the File menu and select Options from the left navigation pane to open the Excel Options dialog. Learn More Buy Introducing the Excel Options Dialog

Excel 2016 save as options