O'Reilly logo

Microsoft Excel 2010 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required