The worksheet status in Excel: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „<imagemap>Datei:Excel Status Menüband.jpg|center|1200px rect 1 79 208 190 Die_Basisfunktionen_von_firesys rect 210 82 487 189 Das_StatusCockpit rect 4…“) |
Keine Bearbeitungszusammenfassung |
||
| Zeile 25: | Zeile 25: | ||
<div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:StatusCockpit4.png|link=Das_StatusCockpit]] [[Das_StatusCockpit|The StatusCockpit]]</div> | <div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:StatusCockpit4.png|link=Das_StatusCockpit]] [[Das_StatusCockpit|The StatusCockpit]]</div> | ||
[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=Das_StatusCockpit]] | <!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=Das_StatusCockpit]]--> | ||
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. <small>'''[[Das_StatusCockpit|more]]'''</small> | 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. <small>'''[[Das_StatusCockpit|more]]'''</small> | ||
| Zeile 33: | Zeile 33: | ||
| style="width: 30%"|<!-- ABS.1: Mittlere Spalte ---------------------------------------------------------------------> | | style="width: 30%"|<!-- ABS.1: Mittlere 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:rxbtnCellSheetInspector_32.png|link=Der_Blatt-Inspektor]] [[Der_Blatt-Inspektor|The worksheet inspector]]</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:rxbtnCellSheetInspector_32.png|link=Der_Blatt-Inspektor]] [[Der_Blatt-Inspektor|The worksheet inspector]]</div> | ||
[[Datei:Blatt-Inspektor.jpg|left|175px|Testbild|link=Der_Blatt-Inspektor]] | <!--[[Datei:Blatt-Inspektor.jpg|left|175px|Testbild|link=Der_Blatt-Inspektor]]--> | ||
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>'''[[Der Blatt-Inspektor|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>'''[[Der Blatt-Inspektor|mehr]]'''</small> | ||
----- | ----- | ||
| Zeile 40: | Zeile 40: | ||
| 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=Der_Blatt-Navigator]] [[Der_Blatt-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=Der_Blatt-Navigator]] [[Der_Blatt-Navigator|The worksheet navigator]]</div> | ||
[[Datei:Blatt-Navigator.jpg|left|175px|Testbild|link=Der_Blatt-Navigator]] | <!--[[Datei:Blatt-Navigator.jpg|left|175px|Testbild|link=Der_Blatt-Navigator]]--> | ||
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>'''[[Der_Blatt-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>'''[[Der_Blatt-Navigator|more]]'''</small> | ||
----- | ----- | ||
| Zeile 50: | Zeile 50: | ||
<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:rxbtnCellShowPrintarea_32.png|link=Der_Blattstatus]] [[Der_Blattstatus|The worksheet status]]</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:rxbtnCellShowPrintarea_32.png|link=Der_Blattstatus]] [[Der_Blattstatus|The worksheet status]]</div> | ||
[[Datei:BlattStatus.jpg|left|175px|Testbild|link=Der_Blattstatus]] | <!--[[Datei:BlattStatus.jpg|left|175px|Testbild|link=Der_Blattstatus]]--> | ||
Here you can determine the status of every worksheet. Coloured highlighting is displayed for each worksheet. <small>'''[[Der_Blattstatus|more]]'''</small> | Here you can determine the status of every worksheet. Coloured highlighting is displayed for each worksheet. <small>'''[[Der_Blattstatus|more]]'''</small> | ||
| Zeile 58: | Zeile 58: | ||
| style="width: 30%"|<!-- ABS.1: Mittlere Spalte ---------------------------------------------------------------------> | | style="width: 30%"|<!-- ABS.1: Mittlere 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:rxbtnCellRollForward_32.png|link=Die_Vorrollen-Funktion]] [[Die_Vorrollen-Funktion|The rolling forward function]]</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:rxbtnCellRollForward_32.png|link=Die_Vorrollen-Funktion]] [[Die_Vorrollen-Funktion|The rolling forward function]]</div> | ||
[[Datei:Vorrollen.jpg|left|175px|Testbild|link=Die_Vorrollen-Funktion]] | <!--[[Datei:Vorrollen.jpg|left|175px|Testbild|link=Die_Vorrollen-Funktion]]--> | ||
Use the rolling forward function in Excel to prepare your report for the next quarter or financial year. After the setup process, you will now benefit from the “automatic” rolling forward process. <small>'''[[Die_Vorrollen-Funktion|more]]'''</small> | Use the rolling forward function in Excel to prepare your report for the next quarter or financial year. After the setup process, you will now benefit from the “automatic” rolling forward process. <small>'''[[Die_Vorrollen-Funktion|more]]'''</small> | ||
----- | ----- | ||
| Zeile 64: | Zeile 64: | ||
| 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:rxbtnCellSetColors_32.png|link=Farbige_Markierungen_in_Excel]] [[Farbige_Markierungen_in_Excel|Coloured highlighting]]</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:rxbtnCellSetColors_32.png|link=Farbige_Markierungen_in_Excel]] [[Farbige_Markierungen_in_Excel|Coloured highlighting]]</div> | ||
[[Datei:FarbigeMarkierungen.jpg|left|175px|Testbild<link=Farbige_Markierungen_in_Excel]] | <!--[[Datei:FarbigeMarkierungen.jpg|left|175px|Testbild<link=Farbige_Markierungen_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>'''[[Farbige_Markierungen_in_Excel|more]]'''</small> | 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>'''[[Farbige_Markierungen_in_Excel|more]]'''</small> | ||
----- | ----- | ||
Version vom 3. Dezember 2019, 13:49 Uhr
<imagemap>Datei:Excel Status Menüband.jpg|center|1200px rect 1 79 208 190 Die_Basisfunktionen_von_firesys rect 210 82 487 189 Das_StatusCockpit rect 491 82 565 187 Der_Blatt-Inspektor rect 570 82 687 187 Der_Blatt-Navigator rect 691 79 765 187 Der_Blattstatus rect 769 80 840 188 Die_Vorrollen-Funktion rect 850 81 1053 189 Farbige_Markierungen_in_Excel desc none
</imagemap>
| |||||
|
|
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 |
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
| |||
|
|
Use the rolling forward function in Excel to prepare your report for the next quarter or financial year. After the setup process, you will now benefit from the “automatic” rolling forward process. more |
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
| |||
See also
The firesys functions in Excel
The design functions in Excel
Translations in Excel
Validations in Excel