How To Create a New List in Excel

By default the following five lists are available in Microsoft Excel

1. Days of week(short)
2. Days of week (Long)
3. Months (short)
4. Months (Long)
5. Direction

But if you want to add more lists you have to do it manually. Here is how:

1. Go to Tools » Options, go to Custom Lists Tab(second last in first row).
2. Make sure that NEW LIST is selected under Custom Lists. Now start typing your entries in the List Entries box. Type one-by-one and after each entry Press ENTER.

Here I have typed 'new item 1' etc. to show what you have to do exactly.

Click on the ADD button to add your 'New List'

You can also add new List using the Import button given at bottom. Locate the entries using Browse(the square button with a red arrow mark) button. Click Import and all the entries will be imported to your New List.

The following image will make it more clear