6. The Excel Options Dialog
In legacy versions of Excel, many options were controlled through either Tools, Options or Tools, Customize dialog boxes. Tools, Customize was the important place to turn off the adaptive menus and customize the toolbars. Tools, Options led to the busiest dialog box in Excel; the Options dialog has 173 settings on 14 tabs. In addition, the Options dialog had six buttons that would take you to further dialogs. It was a challenge to find something specific in the old Options dialog.
Excel 2010 offers a redesigned Excel Options dialog. Microsoft had the following goals for the Options dialogs for all the Office products:
• Show the most important settings earlier and more clearly, so they can be found. Most of the items ...