Office 2008 for Macintosh: The Missing Manual

Tools Menu

Although all menu items are tools, in a sense, most are grouped together because they have some commonality (such as the Insert and Format menus). The Tools menu, on the other hand, is more general in nature. It includes a mix of text tools, sharing tools, and other miscellaneous functions that are powerful but don’t necessarily have a common thread.

Spelling

Runs a spell check on the frontmost spreadsheet.

Thesaurus

Opens the Reference Tools and looks up the selected word.

Dictionary

Opens the Reference Tools, and looks up the selected word.

Language

Lets you choose your language for spell checking.

AutoCorrect

Opens the AutoCorrect window, where you can edit what Excel tries to correct while you type, such as changing “abbout” to “about.” You can add your own items for Excel to AutoCorrect here.

Error Checking

Checks the sheet for invalid equations and operations. Provides summary.

Share Workbook

Opens the Share Workbook window, where you can change an ordinary workbook into one that can be shared by many Excel fans at once on a network. In this window, you can turn workbook sharing on and off, and you can adjust how changes to the shared workbook are treated.

Track Changes

The Track Changes controls how Excel keeps tabs of changes to worksheets and workbooks made by your collaborators. This menu has two submenu options:

• Highlight Changes. Opens the Highlight Changes window, where you can turn change tracking on and control which changes are highlighted.

• Accept or Reject Changes. Walks ...