The worksheet navigator

The navigator provides you with an overview of all worksheets, assigned ranges, Excel errors (such as reference errors) and a list of hidden worksheets or individual cells.

<imagemap>Datei:Excel Status Menüband-Blatt-Navigator.jpg|1200px|center rect 3 85 219 203 Die_Basisfunktionen_von_firesys rect 224 85 511 202 Das_StatusCockpit rect 515 85 593 201 Der_Blatt-Inspektor rect 597 86 721 202 Farbige_Markierungen_in_Excel rect 725 86 800 200 Der_Blatt-Navigator rect 802 85 885 200 Der_Blattstatus rect 890 83 1108 201 Die_Vorrollen-Funktion

desc none </imagemap>

An overview of the functions of the worksheet navigator

Here you see a sample overview of the worksheet navigator. You can find additional information about all components under - .

Set status

Here you can determine the status of each worksheet. The following options are available.

• Approved | green tab color
• Pending | yellow tab color
• Draft | red tab color
• No status | no tab color
• Status n.n. (not necessary) | grey tab color

	Good to know
	The statuses awarded in linkvalidation are transferred to Word in the Excel data manager. The “Approved” status is applied to the worksheet as additional worksheet protection.

If the “Automatically manage tab colours” option is activated in the “ Settings” menu, the worksheet tab colours will be set automatically according to their status (see Automatically apply tab colours).

View

Expand all/reduce all

Expands or reduces all objects in the list. This makes more information available to you.

Search & filter

Opens the search field to search the object list for certain information. Determine which objects are shown in the list. You can also filter by sheet status, errors in cells and sheet protection. Multiple filters can be combined. The view can be reset by choosing “Remove filter”.

Help

Opens the help area which supports you as you work.

The list area

Here you will find a detailed overview of all worksheets in your workbook.

List of all worksheet names

Here you see a list of all available worksheets in the currently opened document, aligned with the sequence of the tabs.

Information on activated sheet protection

If your document contains worksheets that are protected, a green padlock is displayed in the column on the right.

Information about hidden worksheets

If you have hidden entire worksheets in your document, a green/black eye icon is displayed in the column on the right.

Number of Excel errors on the worksheet

If there are any errors in an Excel worksheet, firesys displays the number of errors here. If you expand the view, the individual errors are displayed in a list.

	Good to know
	By double-clicking on an object in the Navigator window, you navigate to the respective object in the Excel file.. You must close the Navigator in order to continue working in the Excel document.

See also

The worksheet status in Excel
The StatusCockpit
The worksheet inspector
The worksheet status in Excel
The rolling forward function
Coloured highlighting in Excel

Further contents

→ firesys website
→ Customer area
→ YouTube