Custom Lists In Excel

In Excel there is a feature that enables us to create a custom list with names, locations, products or whatever else we need. Once created, we can use the AutoFill handle to fill these list items in a workbook.

For example I have typed in an Excel worksheet different sorts of certifications for Office users and I am tired of typing them over and over again every time that is necessary. What can I do?

I can create a Custom List with these certifications, and then by typing only one sequence of these certifications in a cell, and then dragging the AutoFill handle to the rest of the blank cells either horizontally either vertically the list will be completed.

Let’s see how this can be done.

First of all we must type the cells the list of names, locations, etc, that we want to be used as shown in the example below.


Once we have typed in the list we must select the list of names and then:

For Excel 2007: We click on the Office button and then we click on Excel Options which is located at the bottom of the menu. The Excel Options dialog box appears, where we select the Popular category from the left of the window and then from the section Top Options For Working With Excel we click the Edit Custom Lists buttons.

For Excel 2010: We click the File tab in order to go to backstage View and then select the category Options. Once the Options dialog box appears we select the Advanced category from the left. Then from the right of the window, we locate the General section and then select the Edit Custom Lists button.

For either Excel 2007 or Excel 2010 the Custom List window appears as shown in the image below:


At the bottom of the window and at the right of the area Import List From Cells, we notice the selected area of our cells (in our case $A$1:$A$30). All we have do to now is to press the Import button at the right and we will see our list imported in the Custom Lists dialog box as shown in the image below.


Once the list is imported we press the OK button twice in order to return to our spreadsheet. All we have to do now is to go to the cell where we have typed a sequence of our list, and then we move our mouse at the bottom right corner of the cell where we will notice a small black cross appearing where we just drag and drop with our mouse to the area of the cells (this procedure is called AutoFill) that are needed as we can see in the image below.


If we hadn’t typed our list from before in our spreadsheet, we could have done it right in the Custom Lists dialog box. All we had to do was to type our list below the area of the window named List Entries, and once finished we would have just pressed the Add button.

Once a list is not needed anymore we can delete it from the Custom Lists dialog box, by selecting the specific list and by pressing the Delete button.


About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on March 1, 2012, in Excel 2010 English, Microsoft Office 2010 English and tagged , , , , . Bookmark the permalink. Comments Off on Custom Lists In Excel.

Comments are closed.