Automating your frequently used lists

Do you frequently use a list of items that you have to type in every now and then? For example, a list of your department staff names in a certain order, where every time you need to either look them up in another sheet here or there to copy them from, or more painstakingly type them in one by one; or a list of departments names in your organization sorted in a certain way.

A common list used by almost every Excel user is the months (Jan, Feb...etc.). Have you ever wondered how MS Excel is smart enough to complete that list for you?

If you happen to be doing such repetitive tasks every now and then, this post provides you with the simple solution.

In Excel, you can create custom lists that you use frequently as follows:

1. Go to File --> Options --> Advanced --> Edit Custom Lists (Under General)

You should end up with the following dialogue box:


You will notice that there are preexisting lists for days and months, which explains how Excel is able to complete a list automatically.

2. Make sure that the selection under Custom lists is NEW LIST, then under List entries you can start entering the elements of your list separated by commas, then press Add.

If you have already entered the list directly in an open sheet, you may import the list entries directly from there without the need to re-type them. Under Import list from cells, select the cells that contain the list elements then press Import. You will notice that a new list has been created (with the name of the first element in the selected list) with all list entries as per your selection.

Press OK.

3. Try the new list by entering the first entry in an empty cell then drag the cell down. 
 
Voila! No more need to repeat the list! Excel should do it for you!

If you like this post, please do not hesitate to share!