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.
