How To Create A Custom List In Excel 2010

Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Importing Custom Lists.

Importing Custom Lists

Custom lists are a rather esoteric Excel feature that allows you to specify ordered lists of information for virtually any purpose. For instance, a list might include a series of classes or workshops, or it might include a series of employee names. Custom lists can be used when sorting data tables, and they can be used by the AutoFill feature.

How you create a custom list from scratch has been covered in other issues of ExcelTips. Rather than creating a list from scratch, however, you might find it easier to import a list from a series of cells already in your worksheet. Follow these steps:

Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 or a later version, display the File tab of the ribbon and then click Options.)
If you are using Excel 2007, make sure Popular is selected at the left of the dialog box. If you are using Excel 2010 or a later version, click Advanced and then scroll toward the end of the options until you see the General area.
Click Edit Custom Lists. Excel displays the Custom Lists dialog box and hides the Excel Options dialog box. (See Figure 1.)

Figure 1. The Custom Lists dialog box.

Click once in the Import List from Cells box.
Either enter the address range that contains the list you want imported, or use the mouse to select the range on the worksheet.
Click Import. The values from the selected cells are listed in the List Entries box.
Click OK to close the Custom Lists dialog box. The Excel Options dialog box reappears.
Click OK to close the Excel Options dialog box.

You can now use the custom list as you would any other custom list in Excel.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6243) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Importing Custom Lists.

Author Bio

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more about Allen...

MORE FROM ALLEN

Changing the Format for a Date Inserted Using the Keyboard Shortcut

If you are having difficulties getting Word to insert the date exactly the way you want, it could have to do with how you ...

Discover More

Fonts in the Font Drop-Down List

Ever wonder how to customize which fonts appear in the Font drop-down list? Making changes to this list is not easy. This ...

Discover More

Understanding Computer Names

Every Windows computer on your network has a name. This name typically provides some identifying information about the ...

Discover More

More ExcelTips (ribbon)

Automatically Sorting as You Enter Information

When entering information into a worksheet, you may want it to always be in a correctly sorted order. Excel allows you to ...

Discover More

Too Many Formats when Sorting

Sorting is one of the basic operations done in a worksheet. If your sorting won't work and you instead get an error ...

Discover More

Non-standard Sorting

Information in a cell can be entered using line feeds, which results in multiple lines of data in the same cell. If you ...

Discover More