The worksheet status in Excel: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 1: | Zeile 1: | ||
<imagemap> | <imagemap>Image:EN_Excel_Menüband_Status.jpg|Subtitle of Image Map EN_Excel_Men%FCband_Status_Blatt-Inspektor.jpg | ||
rect | rect 4 83 210 195 [[The_basic_functions_of_firesys]] | ||
rect | rect 213 85 471 195 [[The_StatusCockpit]] | ||
rect | rect 482 86 561 194 [[The_worksheet_inspector]] | ||
rect | rect 567 83 685 195 [[Coloured_highlighting_in_Excel]] | ||
rect 691 | rect 691 81 762 196 [[The_worksheet_navigator]] | ||
rect | rect 765 80 830 197 [[The_worksheet_status]] | ||
desc none | desc none | ||
</imagemap> | </imagemap> | ||
Version vom 22. April 2020, 07:11 Uhr
<imagemap>Image:EN_Excel_Menüband_Status.jpg|Subtitle of Image Map EN_Excel_Men%FCband_Status_Blatt-Inspektor.jpg rect 4 83 210 195 The_basic_functions_of_firesys rect 213 85 471 195 The_StatusCockpit rect 482 86 561 194 The_worksheet_inspector rect 567 83 685 195 Coloured_highlighting_in_Excel rect 691 81 762 196 The_worksheet_navigator rect 765 80 830 197 The_worksheet_status desc none </imagemap>
| |||||
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 |
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
|
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
Maintain Excel contents