The default method for saving, AutoRecovery settings, legacy colors, and web server options.Ĭhoose the editing language, ToolTip language, and Help language. Spell-check options and a link to the AutoCorrect dialog box. When Power Query replaced Get Data on the Data tab of the ribbon, the old legacy icons were removed. It offers the new Edit Default Layout for pivot tables, several other pivot table options, and then a series of checkboxes to bring back the legacy Get Data categories. 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, the 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 Excel Options Dialog Box 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 box has categories for General, Formulas, Data, Proofing, Save, Language, Ease Of Access, 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 box.

Excel dialog box launcher