The worksheet navigator

Aus firesys Hilfe
Version vom 19. November 2021, 12:42 Uhr von K.krautscheid (Diskussion | Beiträge)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Zur Navigation springen Zur Suche springen

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.


EN Menüband Excel Status Information Navigator.jpg



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 Firesys Icons BubbleOrange 1 white background.png - Firesys Icons BubbleOrange 3 white background.png.


EN Excel Status Blatt-Navigator.jpg


Firesys Icons BubbleOrange 1 white background.png 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


Glühbirne neu.png
Good to know

The statuses awarded in toolsvalidation 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).

Firesys Icons BubbleOrange 2 white background.png View

Image.Common.Manager.AllItems.Expand.48.png Expand all/ Image.Common.Manager.AllItems.Reduce.48.pngreduce all

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

Image.Common.Manager.Search.Orange.48.png 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”.

Image-Help.48.png Help

Opens the help area which supports you as you work.

Firesys Icons BubbleOrange 3 white background.png The list area

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

Firesys Icons BubbleTransparent 1 white background.png 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.

Firesys Icons BubbleTransparent 2 white background.png Information on activated sheet protection

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

Firesys Icons BubbleTransparent 3 white background.png 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.

Firesys Icons BubbleTransparent 4 white background.png 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.


Glühbirne neu.png
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

Navigation hoch.svg The worksheet status in Excel
Navigation rechts.svg The StatusCockpit
Navigation rechts.svg The worksheet inspector
Navigation rechts.svg The worksheet status
Navigation rechts.svg The rolling forward function
Navigation rechts.svg Coloured highlighting in Excel

Further contents

firesys website
Customer area
YouTube