From LibreOffice Help
Jump to: navigation, search

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


Checks spelling manually.


Opens a submenu where you can choose language specific commands.


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.

Goal Seek

Opens a dialog where you can solve an equation with a variable.


Opens the Solver dialog. A solver allows you to solve equations with multiple unknown variables by goal-seeking methods.


Defines a scenario for the selected sheet area.

Protect Document

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

Cell Contents

Opens a submenu with commands to calculate tables and activate AutoInput.


Opens the Gallery deck of the Sidebar, where you can select images and audio clips to insert into your document.

Media Player

Opens the Media Player window where you can preview movie and sound files as well as insert these files into the current document.


Lets you record or organize and edit macros.

Extension Manager

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

XML Filter Settings

Opens the XML Filter Settings dialog, where you can create, edit, delete, and test filters to import and to export XML files.

AutoCorrect Options

Sets the options for automatically replacing text as you type.


Customizes LibreOffice menus, shortcut keys, toolbars, and macro assignments to events.


This command opens a dialog for a customized program configuration.