Vorlage:Video-Vorrollen mit mehreren gleichen Stichtagen-English

The explanation of each step in detail

How to prepare the roll forward of a table with several equal key dates:

1. In Excel, click the "Configure" button in the "*Content" ribbon in the "Roll forwards" group.
   → The "Roll forwards" task pane opens on the right-hand side.

2. In the task pane, under "Account group", select the account group for which the values exist.

3. Select one cell at a time in the columns you want to roll forward and click the green "Add" plus in the "Columns" group in the "Roll Forward" task pane.
   → The selected columns will be displayed in the list area. A blue arrow indicates in which direction is rolled forward.

4. Assign the appropriate key date to each column in the list area on the right.

5. To configure groups for roll forward, select the last element of the group you want to create and click the left icon "Create group" in the "Roll forward" task pane in the "Groups" group.
   → A separation will now appear below the selected line so that the blue arrows are interrupted at this point.

6. Click the "Save" icon in the "Changes" group in the "Roll forwards" task pane to save the defined groups and automatically close the task pane.
   → The task pane is closed automatically.