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 ...

Get Microsoft Excel 2010 In Depth now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.