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!