Chapter 6. The Excel Options Dialog

In this chapter

Introducing the Excel Options Dialog 104

Toggling the New Excel 2007 Features 107

Controlling the Look and Feel of the Worksheet Window 108

Guide to Excel Options 112

In previous versions of Excel, many options were controlled through either Tools, Options or Tools, Customize dialog. Tools, Customize was the important place to turn off the adaptive menus and to 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.

Fortunately, Microsoft has completely redesigned ...

Get Special Edition Using Microsoft® Office Excel® 2007 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.