Custom Lists

Often we fill out tables with data that are meaningful strings. This can be for example the days of the week, the names of months, and so on. Therefore, it would be convenient to have automation using just enough to enter only the first member of the string, for example, “MONDAY”, and when applying a fill-in technique to Excel, automatically fill in the other several selected fields with the names of the remaining days of the week. This automatics are the Custom Lists and will be referred to in the following text.

User lists are data sets that are predefined or defined by ourselves, and we use them to automatically fill selected columns or rows. To see which user lists exist, or create some new lists, we need to enter the Backstage View, clicking on the File tab, and then choosing Options / Advanced and in the General options group, we find the Edit Custom Lists button. Clicking this button opens the Custom Lists dialog box.

On the left side of the window we can see the existing cell. By clicking on one of them, in the List Entries field on the right, the members of the string that belong to that user list will appear. If we want to add a new list, we need to select the New List option in the window on the left, and then on the right, one below the other, enter the elements of the string that make up this list. By clicking the Add button we will add a new list. If we want to delete the existing list, we will first select it in the menu on the left, and then by clicking the Delete button, we delete this list.

We can also add user lists from a group of cells that are in a worksheet. First, you need to fill in the column with the values ​​of the string that we want to find in the list, and after opening the Custom Lists dialog, at its lower right corner, you need to manually or by the selection enter the range in which these values ​​are. By clicking the Import button, you are importing a user defined list.

Excel immediately after the installation has user lists with names of days in a week and months. Depending on regional settings, these user lists will be in English, Serbian or some other language. Users can add their own lists themselves, and they should be data sets that are often used. For example, a list of employees in a company, a list of organizational units, a job hierarchy …