The rolling forward function: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 2: | Zeile 2: | ||
<imagemap>Datei: | <imagemap>Datei:EN-Excel_Status_Menüband-Vorrollen.jpg|1200px|center | ||
rect 3 85 219 203 [[Die_Basisfunktionen_von_firesys]] | rect 3 85 219 203 [[Die_Basisfunktionen_von_firesys]] | ||
rect 224 85 511 202 [[Das_StatusCockpit]] | rect 224 85 511 202 [[Das_StatusCockpit]] |
Version vom 6. Januar 2020, 09:18 Uhr
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. The current worksheet, the entire workbook or the validations can be rolled forward optionally.
<imagemap>Datei:EN-Excel_Status_Menüband-Vorrollen.jpg|1200px|center
rect 3 85 219 203 Die_Basisfunktionen_von_firesys
rect 224 85 511 202 Das_StatusCockpit
rect 515 85 593 201 Der_Blatt-Inspektor
rect 597 86 721 202 Farbige_Markierungen_in_Excel
rect 725 86 800 200 Der_Blatt-Navigator
rect 802 85 885 200 Der_Blattstatus
rect 890 83 1108 201 Die_Vorrollen-Funktion
desc none </imagemap>
Die Vorrollen-Funktion
In the first step you define the columns for the rolling forward function. This is done by using the “Rolling forward” dialog, which you can access via the Excel menu ribbon (see screenshot).
Display columns
Selects all columns on the worksheet that were defined for rolling forward.
Add columns
Select a column which should be rolled forward in future. To add a column, you simply need to position the cursor in any cell in this column and to press the button.
Good to know
| |
---|---|
Columns outside of the print area can also be marked for the rolling forward process. Columns to be rolled forward do not necessarily have to be next to each other. |
Change, remove and move columns
Of course, all columns to be rolled forward can be changed or removed or their sequence can be changed.
Gut zu wissen
| |
---|---|
Tables with horizontally linked cells cannot be rolled forward. |
See also
The worksheet status in Excel
The StatusCockpit
The worksheet inspector
The worksheet navigator
The worksheet status in Excel
Coloured highlighting in Excel