The rolling forward function: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(5 dazwischenliegende Versionen von einem anderen Benutzer werden nicht angezeigt)
Zeile 2: Zeile 2:




<imagemap>Datei:EN-Excel_Status_Menüband-Vorrollen.jpg|1200px|center
<imagemap>Datei:EN_Menüband_Excel_Inhalt_Vorrollen.jpg|1200px|center
rect 3 85 219 203 [[The_basic_functions_of_firesys]]
 
rect 224 85 511 202 [[The_StatusCockpit]]
rect 515 85 593 201 [[The_worksheet_inspector]]
rect 597 86 721 202 [[Coloured_highlighting_in_Excel]]
rect 725 86 800 200 [[The_worksheet_navigator]]
rect 802 85 885 200 [[The_worksheet_status]]
rect 890 83 1108 201 [[The_rolling_forward_function]]
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
desc none
desc none
Zeile 15: Zeile 9:




== Die Vorrollen-Funktion ==
== The rolling forward function ==
[[Datei:Excel Validierung Vorrollen.jpg|mini|upright=2.0|The work area for the rolling forward function]]
[[Datei:EN Excel Validierung Vorrollen.jpg|mini|upright=2.0|The work area for the rolling forward function]]


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).  
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).  


== [[Datei:firesys_Icons_BubbleTransparent_1_white_background.png|link=|20px]] Display columns ==
=== [[Datei:firesys_Icons_BubbleTransparent_1_white_background.png|link=|20px]] Display columns ===


Selects all columns on the worksheet that were defined for rolling forward.  
Selects all columns on the worksheet that were defined for rolling forward.  


== [[Datei:firesys_Icons_BubbleTransparent_2_white_background.png|link=|20px]] Add columns ==
=== [[Datei:firesys_Icons_BubbleTransparent_2_white_background.png|link=|20px]] 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.  
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.  
Zeile 37: Zeile 31:




== [[Datei:firesys_Icons_BubbleTransparent_3_white_background.png|link=|20px]] Change, remove and move columns ==
=== [[Datei:firesys_Icons_BubbleTransparent_3_white_background.png|link=|20px]] Change, remove and move columns ===


Of course, all columns to be rolled forward can be changed or removed or their sequence can be changed.  
Of course, all columns to be rolled forward can be changed or removed or their sequence can be changed.  
Zeile 43: Zeile 37:


{{
{{
Vorlage:Gutzuwissen
Vorlage:GoodtoKnow


|Gutzuwissen = Tables with horizontally linked cells cannot be rolled forward.
|Gutzuwissen = Tables with horizontally linked cells cannot be rolled forward.

Aktuelle Version vom 25. März 2021, 13:23 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_Menüband_Excel_Inhalt_Vorrollen.jpg|1200px|center

desc none </imagemap>


The rolling forward function

The work area for the rolling forward function

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).

Firesys Icons BubbleTransparent 1 white background.png Display columns

Selects all columns on the worksheet that were defined for rolling forward.

Firesys Icons BubbleTransparent 2 white background.png 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.


Glühbirne neu.png
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.


Firesys Icons BubbleTransparent 3 white background.png Change, remove and move columns

Of course, all columns to be rolled forward can be changed or removed or their sequence can be changed.


Glühbirne neu.png
Good to know

Tables with horizontally linked cells cannot be rolled forward.

See also

Navigation hoch.svg The worksheet status in Excel
Navigation rechts.svg The StatusCockpit
Navigation rechts.svg The worksheet inspector
Navigation rechts.svg The worksheet navigator
Navigation rechts.svg The worksheet status in Excel
Navigation rechts.svg Coloured highlighting in Excel

Further contents

firesys website
Customer area
YouTube