How to create a custom list in Excel

A list is a collection of items under a specific category. Excel has four built-in lists such as month abbreviation, month full name, day of the week abbreviation and week full name. In some cases, the available built-in lists are not enough. Excel enables us to create our own lists as per our requirements, called custom lists. You can type cell details and drag horizontally or vertically to have the series automatically filled. You can even import custom lists across multiple workbooks or worksheets. Here are the steps to create a custom list in Excel.

Method One: Create a Custom List

Step 1: Open MS Excel by typingExcel in the search space in the left corner.

Step 2:Double-click Excel to open it.

Step 3:ClickFile.

Step 4:Go tooptions

##Step 5:InExcel Options, scan toAdvancedand find theGeneralsection.

Step 6: In the General section, we need to create our own list by clicking onEdit Custom Lists.

Step 7:After clicking the "Edit Custom List" button, the "Custom List"screen will open , you can add lists as needed.

Step 8: ClickNew Listand write the list into theList Entriesbox . List items can be separated by commas or by pressing the Enter key. When you have completed your list entries, clickAdd.

Step 9:After clicking Add, the list entries will be added to the custom list box. ClickOK.

Step 10:Now the custom list is added to the Excel worksheet. You just enter the first word in the list (which is English according to the example in the custom list above) and drag the fill handle to complete the list.

Type the first word in the cell and drag horizontally or vertically to automatically fill the row or column.

Method 2: How to import a list of items from a worksheet into a custom list

A custom list can be created from details in a spreadsheet, which can then be imported as follows

If a large number of items already exist in the spreadsheet, you can use the import function to create a new custom list. Created lists can be reused anywhere without having to re-enter the list of items.

Step 1:To open theCustom Listscreen, go toOptionsand selectAdvanced. In theGeneralsection, clickEdit Custom List.

Step 2: In the "Import list from cells" box, enter thecell range of the list that must be imported.If you are unable to provide the cell range details, you can use your cursor to drag the list of cells to get the range details that must be filled automatically.

In the above example, the cell range is column A and the rows start from 2 to 6, so it is expressed as $A$2:$A$6.

Step 3:ClickImport

Step 4:After the import is completed, we canView details in List Entries.

Step 5:Now thecustom listis created. You can use it wherever you need it.

Step 6:You can type the first cell details and drag vertically to autofill into the column.

Step 7:If you want to fill the cells row by row, drag horizontally.

Method Three: Edit or Delete Custom List

If there are any changes in the existing list, such as additions or deletions, please click fromSelect the Define Listbox and make changes in theList Entry, then clickAdd. By doing this we are not creating a new list, just updating the existing list.

In the example, we delete 2 items from the list entries.

After deleting the unwanted entries, clickAddto update the list.

#When the custom list is updated, autofill will update accordingly.

Performdeletion of an entire list by selecting from a custom list box and clicking Delete.

#Click OK to permanently confirm the deletion from the custom list.

The above is the detailed content of How to create a custom list in Excel. For more information, please follow other related articles on the PHP Chinese website!