The worksheet status in Excel: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| (2 dazwischenliegende Versionen von einem anderen Benutzer werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
[[Datei:EN_Menüband_Excel_Status.jpg|center|1200px]] | |||
{| class="toptextcells" style="padding: 5px; border:none; background:#FFFFFF; width:100%; border-spacing:10px;" | {| class="toptextcells" style="padding: 5px; border:none; background:#FFFFFF; width:100%; border-spacing:10px;" | ||
| Zeile 27: | Zeile 26: | ||
The worksheet inspector helps you track down errors and inconsistencies. It does this by displaying relevant information about the current worksheet in a task area in Excel. Missing translations, Excel errors or hidden rows or columns are clearly shown. <small>'''[[The_worksheet_inspector|mehr]]'''</small> | The worksheet inspector helps you track down errors and inconsistencies. It does this by displaying relevant information about the current worksheet in a task area in Excel. Missing translations, Excel errors or hidden rows or columns are clearly shown. <small>'''[[The_worksheet_inspector|mehr]]'''</small> | ||
----- | ----- | ||
| style="width: 30%"|<!-- ABS.1: Rechte Spalte -----------------------------------------------------------------------> | |||
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnCellSetColors_32.png|link=Coloured_highlighting_in_Excel]] [[Coloured_highlighting_in_Excel|Coloured highlighting in Excel]]</div> | |||
<!--[[Datei:FarbigeMarkierungen.jpg|left|175px|Testbild<link=Coloured_highlighting_in_Excel]]--> | |||
By using coloured highlighting, you always have a quick overview of how up to date your data is and any potential errors, and you can set and remove your own highlighting for linked objects <small>'''[[Coloured_highlighting_in_Excel|more]]'''</small> | |||
----- | |||
|- | |||
| style="width: 30%"|<!-- ABS.1: Rechte Spalte -----------------------------------------------------------------------> | | style="width: 30%"|<!-- ABS.1: Rechte Spalte -----------------------------------------------------------------------> | ||
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnCellExcelNavigator_32.png|link=The_worksheet_navigator]] [[The_worksheet_navigator|The worksheet navigator]]</div> | <div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnCellExcelNavigator_32.png|link=The_worksheet_navigator]] [[The_worksheet_navigator|The worksheet navigator]]</div> | ||
| Zeile 34: | Zeile 40: | ||
The worksheet navigator provides you with an overview of all worksheets, allocated areas, Excel errors (such as reference errors) as well as a list of the hidden worksheets or individual cells. <small>'''[[The_worksheet_navigator|more]]'''</small> | The worksheet navigator provides you with an overview of all worksheets, allocated areas, Excel errors (such as reference errors) as well as a list of the hidden worksheets or individual cells. <small>'''[[The_worksheet_navigator|more]]'''</small> | ||
----- | ----- | ||
| style="width: 30%"|<!-- ABSCHNITT 1 -------------------------------------------------------------------------------> | | style="width: 30%"|<!-- ABSCHNITT 1 -------------------------------------------------------------------------------> | ||
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------> | <!-- ABS.1: Linke Spalte ------------------------------------------------------------------------> | ||
| Zeile 44: | Zeile 49: | ||
Here you can determine the status of every worksheet. Coloured highlighting is displayed for each worksheet. <small>'''[[The_worksheet_status|more]]'''</small> | Here you can determine the status of every worksheet. Coloured highlighting is displayed for each worksheet. <small>'''[[The_worksheet_status|more]]'''</small> | ||
---- | ---- | ||
<br /> | <br /> | ||
|- | |- | ||
Aktuelle Version vom 19. November 2021, 12:39 Uhr
| |||||
|
The StatusCockpit provides you with an overview of your Excel file. Both sheets and areas are presented here in a clear overview and can be accessed directly. The status that you can give to individual sheets via the navigator is shown here. more
|
The worksheet inspector helps you track down errors and inconsistencies. It does this by displaying relevant information about the current worksheet in a task area in Excel. Missing translations, Excel errors or hidden rows or columns are clearly shown. mehr
|
By using coloured highlighting, you always have a quick overview of how up to date your data is and any potential errors, and you can set and remove your own highlighting for linked objects more | |||
|
The worksheet navigator provides you with an overview of all worksheets, allocated areas, Excel errors (such as reference errors) as well as a list of the hidden worksheets or individual cells. more
|
Here you can determine the status of every worksheet. Coloured highlighting is displayed for each worksheet. more
| ||||
See also
The firesys functions in Excel
Design an Excel document
Translations in Excel
Maintain Excel contents