A Custom List in Excel is very handy to fill a range of cells with your own personal list. It could be a list of your team members at work, countries, regions, phone numbers or customers.

The main goal of a custom list is to remove repetitive work and manual errors in inputting.

DOWNLOAD EXCEL WORKBOOK

 
To demonstrate the power of Excel’s Custom Lists, we’ll explore what’s currently in Excel’s memory as a default list:

STEP 1: Type February in the first cell

Custom List-1

 

STEP 2: From that first cell, click the lower right corner and drag it to the next 5 cells to the right

Custom List-02

 

STEP 3: Release and you will see it get auto-populated to July (The succeeding months after February)

Custom List-03

 

At first, it might seem like magic on how Excel does this!

Let us go straight into the Options in Excel to view how it’s being done, and how you can create your own Custom List:

STEP 4: Select the File tab

Custom List-04

 

STEP 5: Click Options

Custom List-05

 

STEP 6: Select the Advanced option

Custom List-06

 

STEP 7: Scroll all the way down and under the General section, click Edit Custom Lists

Custom List-07

 

Here you can see the built-in default Excel lists of the calendar months, and the days.

If you click on a Custom List, you will see under List entries that it is greyed out and you cannot make any changes.  This indicated that it is a default Excel Custom List.

Default Custom List

 

STEP 8: You can create & add your own Custom List under the List entries section.

Click on NEW LIST under the Custom Lists area and then manually enter your list, entering one entry per line:

create new list

After typing the values, click Add.

In our screenshot below, we added the values of the Greek alphabet (alpha, beta, gamma, and so on)

Click OK once done.

Custom List 08

 

STEP 9: Click OK again

Custom List 09

 

STEP 10: Now let’s go back into our Excel workbook to see our new Custom List in action.  Type alpha on a cell

Custom List 10

 

STEP 11: From that cell, click the lower right corner and drag it to the next 5 cells to the right

Custom List 11

 

STEP 12: Release and you will see it get auto-populated to zeta, which is based on our Custom List created in Step 8

Custom List 12

 

Following is a demonstration of how you can easily create a Custom List in Excel…

Custom List

 

 

HELPFUL RESOURCE:

Oz_Podcast_Banner

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Show The Percent of Row Total With Excel Pivot Tab... Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF ROW TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sales data, exp...
Show The Percent of Grand Total With Excel Pivot T...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF GRAND TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sal...
Distinct or Unique Count with Excel Pivot Tables Excel 2013 added some new features to its arsenal and one that has been well overdue was the distinct or unique count. Previously when we created a Pivot Table and dropped a Customers field in the Row Labels and then again in the Values area we got the "total number of transac...
Pivot Table Count Transactions The default Value Field Setting when analyzing data with a Pivot Table is to Sum, but you can also analyze a Pivot Table with a Count. This is useful when you want to see how many sales transactions  took place within a region, a month, a year or per business unit. DOWNLOAD...