The worksheet status in Excel: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(16 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
<imagemap>Datei:Excel Status Menüband.jpg|center|1200px
[[Datei:EN_Menüband_Excel_Status.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
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
</imagemap>


{| 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 23: Zeile 14:
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<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=The_StatusCockpit]] [[The_StatusCockpit|The StatusCockpit]]</div>


<!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=Das_StatusCockpit]]-->
<!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=The_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>'''[[The_StatusCockpit|more]]'''</small>
----
----




| 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=The_worksheet_inspector]] [[The_worksheet_inspector|The worksheet inspector]]</div>
<!--[[Datei:Blatt-Inspektor.jpg|left|175px|Testbild|link=Der_Blatt-Inspektor]]-->
<!--[[Datei:Blatt-Inspektor.jpg|left|175px|Testbild|link=The_worksheet_inspector]]-->
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>'''[[The_worksheet_inspector|mehr]]'''</small>  
-----
-----
</div>
 


| 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 42: 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>  
-----
-----
</div>
 
<br />
 
|-
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
Zeile 52: 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>
----
----
| 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=The_rolling_forward_function]] [[The_rolling_forward_function|The rolling forward function]]</div>
<!--[[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>'''[[The_rolling_forward_function|more]]'''</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]]</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>
-----
</div>
<br />
<br />
|-
|-
Zeile 75: Zeile 58:
== See also  ==
== See also  ==


[[Datei:Navigation_hoch.svg|link=]] [[Die_firesys-Funktionen_in_Excel|The firesys functions in Excel]] <br>
[[Datei:Navigation_hoch.svg|link=]] [[The_firesys_functions_in_Excel|The firesys functions in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Excel-Gestaltungs-Funktionen|The design functions in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Design_an_Excel_document|Design an Excel document]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Übersetzungen_in_Excel|Translations in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Translations_in_Excel|Translations in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Validierungen_in_Excel|Validations in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Maintain Excel contents|Maintain Excel contents]]  <br>


{{MoreContent}}
{{MoreContent}}
[[Kategorie:Excel Dokument-Blattstatus]]
[[Kategorie:English-Excel Dokument-Blattstatus]]

Aktuelle Version vom 19. November 2021, 12:39 Uhr

EN Menüband Excel Status.jpg



Excel Funktionen 64.png
The worksheet status in Excel

The StatusCockpit and the worksheet inspector provide an overview of your Excel documents, worksheets and areas. To do this, use coloured highlighting to display the status quickly.
Excel Funktionen 64.png

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

Navigation hoch.svg The firesys functions in Excel
Navigation rechts.svg Design an Excel document
Navigation rechts.svg Translations in Excel
Navigation rechts.svg Maintain Excel contents

Further contents

→ firesys website
→ Customer area
→ YouTube

Abgerufen von „https://hilfe.firesys.de/mediawiki/index.php?title=The_worksheet_status_in_Excel&oldid=18259“