The worksheet status: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 20: | Zeile 20: | ||
=== An overview of the individual status options === | === An overview of the individual status options === | ||
[[Datei: | [[Datei:EN-Excel Status Blattstatus.jpg|mini|upright=1.8|The selection dialog of the worksheet status]] | ||
Once you have assigned a status, the display of the respective worksheets changes in the tab – a coloured background appears. | Once you have assigned a status, the display of the respective worksheets changes in the tab – a coloured background appears. |
Version vom 6. Januar 2020, 09:52 Uhr
The firesys worksheet status displays the processing status of the worksheets in your workbook quickly and clearly.
<imagemap>Datei:EN-Excel Status Menüband-Blattstatus.jpg|1200px|center
rect 3 85 219 203 The_basic_functions_of_firesys
rect 224 85 511 202 The_StatusCockpit
rect 515 85 593 201 The_worksheet_inspector
rect 597 86 721 202 Coloured_highlighting_in_Excel
rect 725 86 800 200 The_worksheet_navigator
rect 802 85 885 200 The_worksheet_status
rect 890 83 1108 201 The_rolling_forward_function
desc none </imagemap>
An overview of the function
Here you can determine the status of each worksheet. The following options are available:
An overview of the individual status options
Once you have assigned a status, the display of the respective worksheets changes in the tab – a coloured background appears.
Approved
Green tab colour
Pending
Yellow tab colour
Draft
Red tab colour
Kein Status
No tab colour
Status n.n. (nicht notwendig)
Grey tab colour
Gut zu wissen
| |
---|---|
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”).
The worksheet status history
The worksheet status history is an additional tool from firesys that saves all changes to the worksheet status. You can see when which status was assigned to the currently opened worksheet by which employee.
See also
The worksheet status in Excel
The StatusCockpit
The worksheet inspector
The worksheet navigator
The rolling forward function
Coloured highlighting in Excel