Excel 2010: Creating Custom Lists

There are many built in lists in Excel, numerical, date/time, text and numerical, and some text entries for month and day (try typing Jan in a cell and replicate the sequence down with the bottom right corner of the cell). For sequences that are not immediately available, Excel gives you the option of creating your own customised text lists.

Go to the File tab and select Options. On the Advanced page (tab at the left), scroll down to the General section where you see the Edit Custom Lists button. Click to open the dialog box.

Adding a custom listIf you have a list already in a spreadsheet, select the cells first. Now go to the Custom Lists dialog box and use the Import button to save retyping the entries.