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 fixed value or a sequence of values.

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

If, for example, you create a list with the content "Red", "Green" and "Blue", and then subsequently 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 if required. To do so, choose the ribbon command File | Customize | Customize ribbon to open 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 will also find the command directly via the "Hamburger menu" hamburgermenu: 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 paragraphs for more information.

Creating a new AutoFill list ("New" button)

To create a new AutoFill list for the Fill function, proceed as follows:

1.Choose the command Edit lists.
2.Click on the New button in the following dialog box.
3.Another dialog box appears. Enter the desired list entries in it. 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 list you have created for the Fill function, 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 list you have created for the Fill function, 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 selected cell becomes a list entry.

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