Editing lists for automatic filling

<< Click to Display Table of Contents >>

Editing lists for automatic filling

As described in Filling cells automatically, you can use the command Home | Fill to fill a cell range with a repeating value or a sequence of values.

If you choose the Series entry from the ribbon command Home | group Contents | Fill fill_cells_icon, a dialog box opens. Using the Edit lists button here, you can also create your own lists for the Fill function.

If, for example, you create a list with the content "Red", "Green" and "Blue", and later start a fill operation from a cell that contains the text "Red", PlanMaker will continue the series and fill with Green, Blue, Red, Green, Blue, etc.

Note: You can also add your own Edit lists button to a ribbon tab. To do so, use the ribbon command File | Customize | Customize ribbon to select the dialog box for customizing the user interface, and search there for the command "Edit lists". Then proceed as described in Customizing icons and groups in the ribbon.

You can also find the command directly via the hamburgermenu "Hamburger Menu": Tools > Edit lists

The dialog box of the command Edit lists provides buttons with the following functions:

▪"New" button: create a new list

▪"Edit" button: edit the list created

▪"Delete"button: delete the list created

▪"Import" button: create a list from the currently selected cells

See the following pages for more information.

Creating a new AutoFill list ("New" button)

Proceed as follows to create a new AutoFill list for the Fill feature:

1.Choose the command Edit lists.
2.Click on the New button in the following dialog box.
3.Another dialog box appears. Use it to enter the desired list entries. Please note that each line may only contain one entry. Press the Enter key↵ after each entry to start a new line.
4.Then click on the OK button.

The new list has now been created.

Editing an AutoFill list ("Edit" button)

To edit a user-defined AutoFill list created with the Fill feature, proceed as follows:

1.Choose the command Edit lists.
2.In the following dialog box, select the list to be edited by clicking on it with the mouse.
Note: The predefined sample lists cannot be edited.
3.Click on the Edit button.
4.Another dialog box appears with the list entries. Edit them as desired. Please note that each line may only contain one entry. Press the Enter key↵ after each entry to start a new line.
5.Then click on the OK button.

The list has now been changed accordingly.

Deleting an AutoFill list ("Delete" button)

To delete a user-defined AutoFill list created with the Fill feature, proceed as follows:

1.Choose the command Edit lists.
2.In the following dialog box, select the list to be deleted by clicking on it with the mouse.
Note: The predefined sample lists cannot be deleted.
3.Click on the Delete button.

The list has now been removed.

Importing an AutoFill list from cells ("Import" button)

If a PlanMaker document contains a cell range whose contents you want to save as an AutoFill list, proceed as follows:

1.Select the desired cells.
2.Choose the command Edit lists.
3.In the following dialog box, click on the Import button.

PlanMaker reads the contents of the selected cells and creates a new AutoFill list from them. Each cell becomes a list entry.

If you have selected multiple rows and columns, PlanMaker creates multiple lists accordingly. Before this, a query appears asking whether you want to import the data row by row or column by column. Choose Row by rowif you want each row to become a list, or Column by column if you want each column to become a list.