The worksheet navigator: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 1: Zeile 1:
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]]
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
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 [[File:Firesys Icons BubbleOrange 1 white background.png|link=|16px]] - [[File:Firesys Icons BubbleOrange 3 white background.png|link=|16px]].
[[Datei:Excel Status Blatt-Navigator.jpg|center|1000px]]
== [[File:Firesys Icons BubbleOrange 1 white background.png|link=|24px]] 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
{{
Vorlage:GoodtoKnow
|Gutzuwissen = 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).
== [[File:Firesys Icons BubbleOrange 2 white background.png|link=|24px]] 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.
== [[File:Firesys Icons BubbleOrange 3 white background.png|link=|24px]] The list area ==
Here you will find a detailed overview of all worksheets in your workbook.
=== [[File:Firesys Icons BubbleTransparent 1 white background.png|link=|20px]] 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.
=== [[File:Firesys Icons BubbleTransparent 2 white background.png|link=|20px]] Information on activated sheet protection ===
If your document contains worksheets that are protected, a green padlock is displayed in the column on the right.
=== [[File:Firesys Icons BubbleTransparent 3 white background.png|link=|20px]] 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.
=== [[File:Firesys Icons BubbleTransparent 4 white background.png|link=|20px]] 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.
{{
Vorlage:GoodtoKnow
|Gutzuwissen = 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 ==
== See also ==


Zeile 7: Zeile 93:
[[Datei:Navigation_rechts.svg|link=]] [[The_rolling_forward_function|The rolling forward function]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_rolling_forward_function|The rolling forward function]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Coloured_highlighting_in_Excel|Coloured highlighting in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Coloured_highlighting_in_Excel|Coloured highlighting in Excel]]  <br>
{{MoreContent}}


[[Kategorie:English-Excel Dokument-Blatt-Status-Content]]
[[Kategorie:English-Excel Dokument-Blatt-Status-Content]]

Version vom 18. Dezember 2019, 13:02 Uhr

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


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 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).

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

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 in Excel
Navigation rechts.svg The rolling forward function
Navigation rechts.svg Coloured highlighting in Excel

Further contents

firesys website
Customer area
YouTube