Tools

The Tools menu contains commands to check spelling, to trace sheet references, to find mistakes and to define scenarios.

You can also create and assign macros and configure the look and feel of toolbars, menus, keyboard and set the default options for Office applications.

Spelling

Checks spelling manually.

Automatic Check Spelling

Office can automatically check spelling while you type and underline possible misspelled words with a red wavy line.

Thesaurus

Use the thesaurus to look up synonyms or related terms.

Language

Opens a sub-menu from which you can choose language-specific commands.

AutoCorrect Options

Sets the options for automatically replacing text as you type.

Redaction

Redacting documents blocks out words or portions of a document for authorised use or viewing.

Auto-Redact

Use automatic redaction to define words and patterns that are automatically marked for redaction.

ImageMap

Allows you to attach URLs to specific areas, called hotspots, on a graphic or a group of graphics. An image map is a group of one or more hotspots.

Goal Seek

Opens a dialogue box in which you can solve an equation with a variable.

Solver

Opens the Solver dialogue box. A solver allows you to solve mathematical problems with multiple unknown variables and a set of constraints on the variables by goal-seeking methods.

Detective

This command activates the Spreadsheet Detective. With the Detective, you can trace the dependencies from the current formula cell to the cells in the spreadsheet.

Scenarios

Defines a scenario for the selected sheet area.

Forms Sub-menu

Contains commands for activate form design mode, open control wizards and insert form controls in your document.

Share Spreadsheet

Sharing a spreadsheet allows several users to open the same file for editing at the same time.

Protect Document

The Protect Sheet or Protect Spreadsheet Structure commands prevent changes from being made to cells in the sheets or to sheets in a document. You can optionally define a password. If a password is defined, removal of the protection is only possible if the user enters the correct password.

Macros

Lets you record or organise and edit macros.

Development Tools

Inspects objects in Office documents and shows supported UNO services, as well as available methods, properties and implemented interfaces.

Extension Manager

The Extension Manager adds, removes, disables, enables, and updates Office extensions.

Customise

Customises Office menus, context menus, shortcut keys, toolbars, and macro assignments to events.

Options

This command opens a dialogue box for a customised program configuration.