The worksheet status: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 3: | Zeile 3: | ||
<imagemap>Image:EN_Excel_Menüband_Status_Blattstatus.jpg|center|1200px | <imagemap>Image:EN_Excel_Menüband_Status_Blattstatus.jpg|center|1200px | ||
desc none | desc none | ||
</imagemap> | </imagemap> | ||
| Zeile 51: | Zeile 46: | ||
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”). | 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 [[Settings_in_Excel_–_set_highlighting#Automatically apply tab colours| “Automatically apply tab colours”]]). | ||
== The worksheet status history == | == The worksheet status history == | ||
Version vom 23. Juli 2020, 07:19 Uhr
The firesys worksheet status displays the processing status of the worksheets in your workbook quickly and clearly.
<imagemap>Image:EN_Excel_Menüband_Status_Blattstatus.jpg|center|1200px
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
No Status
No tab colour
Status n.n. (nicht notwendig)
Grey tab colour
 |
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”).
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