O'Reilly logo

Excel 2003: The Missing Manual by Matthew MacDonald

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

Tools Menu

The Tools menu provides quick access to a variety of Excel features, including change tracking, what-if data analysis, formula troubleshooting, and the omnipresent spell checker. You can also use the Customize command to tailor Excel's menus and toolbars and the Options command to review and tweak a cornucopia of Excel settings.

Spelling

The spell checker (Tools Spelling) begins scanning the current worksheet from left to right (in the current row), and then moves down to cover all the rows below the current row. The spell checker examines only cells that contain text, and it verifies each word against its dictionary. When it finds an error, the spell checker prompts you with a list of suggestions, just as in other applications like Word. For more information about customizing the spell checker, see Section 5.3.1 (Chapter 5).

Research

The Research task (Tools Research), which appears on the right side of the Excel window, lets you retrieve all kinds of information from the Internet. The Research task provides a fairly impressive set of services that let you search a dictionary for detailed definitions, a thesaurus for synonyms, and the Encarta encyclopedia for information on a range of topics. You can also get stock market quotes from the MSN Money Web site. Although the Research task's data is usually more suited for a Word document than an Excel workbook, it still provides a great tool for quickly getting oodles of free information. Microsoft hopes that third-party ...

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