How to Import, Edit and Delete Custom Lists in Excel

This guide shows you how to create, import, edit, and delete custom lists in Microsoft Excel. Custom lists let you autofill sequences like weekdays, months, or your own recurring data (e.g., team names, product categories) without retyping. You’ll learn the built-in list manager, how to import a list from a range, and how to remove lists you no longer need.

What You’ll Need

• Microsoft Excel (desktop version for Windows or Mac; the steps are similar in Excel 2016, 2019, 2021, and Microsoft 365).
• If you want to import a list, have the items typed in a single column or row in a worksheet.
• Administrator or standard user rights (no special permissions needed for custom lists).

Step-by-Step

Creating a Custom List from Scratch

1. Open Excel and click the File tab, then Options (or Excel Options on Mac).
2. In the Excel Options dialog, click Advanced in the left sidebar.
3. Scroll down to the General section and click the Edit Custom Lists button.
4. In the Custom Lists dialog, you’ll see a list box on the left with built-in lists (e.g., “Sun, Mon, Tue…” and “Jan, Feb, Mar…”). To add a new one, click NEW LIST in the left pane.
5. In the List entries box on the right, type each item on its own line. For example:
   
   Red
   
   Green
   
   Blue
   
   Yellow
6. Click Add. Your list appears in the left box, and the entries are saved.
7. Click OK to close the dialog, then OK again to close Excel Options.
8. Test it: type the first item in a cell, then drag the fill handle (the small square at the bottom-right of the cell) down or across. Excel fills the rest of the sequence.

Importing a List from a Range

1. Before opening the dialog, select the cells that contain your list items. They must be in a single row or column, with no blank cells.
2. Go to File > Options > Advanced > Edit Custom Lists (same as above).
3. In the Custom Lists dialog, you’ll see the Import list from cells box at the bottom. It should already show the selected range (e.g., $A$1:$A$4). If not, click the range selector icon and select the cells.
4. Click Import. The items appear in the List entries box, and the new list is added to the left pane.
5. Click OK twice to save.

Editing an Existing Custom List

1. Open the Custom Lists dialog as above.
2. In the left pane, click the list you want to edit. Its entries appear in the List entries box.
3. Modify the entries: add new lines, delete lines, or change text. Note: you cannot edit built-in lists (like weekdays or months) — they are locked.
4. After editing, click Add. Excel updates the list. (If you don’t click Add, the changes won’t be saved.)
5. Click OK to close.

Deleting a Custom List

1. Open the Custom Lists dialog.
2. In the left pane, select the custom list you want to delete (not a built-in one — those can’t be removed).
3. Click the Delete button. Excel asks for confirmation; click OK.
4. Click OK to close the dialog. The list is gone.

Common Mistakes

• Forgetting to click Add after editing — if you close the dialog without clicking Add, your changes are lost.
• Importing a range with blank cells — Excel stops at the first blank cell, so you may get a partial list.
• Typing entries with commas instead of line breaks — each entry must be on its own line in the List entries box. If you type “Red, Green, Blue” on one line, it becomes a single item.
• Deleting a built-in list — the Delete button is grayed out for built-in lists; you cannot remove them.
• Using the fill handle without the first item — if you start with a blank cell, Excel may not recognize the pattern.

Tips

• Custom lists are stored in your Excel profile, so they are available in all workbooks on that computer. They are not saved with the workbook.
• To create a list quickly, type the items in a column, select them, and import — faster than typing them again in the dialog.
• You can use custom lists for sorting: in the Sort dialog, choose Custom List under Order to sort by your list order.
• If you need the same list on another computer, you’ll have to recreate it there — there’s no built-in export feature.
• Keep list entries short and consistent; avoid leading/trailing spaces.

Troubleshooting

• Fill handle doesn’t autofill my list — First, make sure the first cell contains the exact first item of your list. Then drag the fill handle. If it still doesn’t work, check that the list is correctly saved (open the Custom Lists dialog and verify). Also, ensure the cell is not formatted as text; if so, change the format to General and retype.
• Import button is grayed out — This happens if you haven’t selected a valid range. Click the range selector and select a contiguous range of cells with text.
• List appears but with extra items — This often happens if you imported a range that included blank rows or hidden rows. Re-import with a clean range.
• Can’t delete a list — If the Delete button is grayed out, you’re trying to delete a built-in list. Only custom lists you created can be deleted.
• Changes to a list don’t affect existing cells — Editing a custom list only affects future autofill operations. Cells already filled with the old list will not update automatically.

Frequently Asked Questions

Can I use custom lists in Excel for the web?

No, the custom list feature is only available in the desktop version of Excel. Excel for the web does not support creating or using custom lists.

How do I remove a custom list I accidentally created?

Open the Custom Lists dialog, select the list in the left pane, and click Delete. Confirm when prompted.

Can I import a list from a text file?

Yes, but not directly. Open the text file in Excel, put the items in a single column, then use the Import from cells feature.

Why does my custom list not show up in the fill handle?

Make sure you type the first item exactly as it appears in the list (case-insensitive, but no extra spaces). If it still doesn’t work, check that the list is saved and try restarting Excel.

Can I use custom lists for data validation?

Yes, you can reference a custom list in a data validation rule by using a named range, but you cannot directly select a custom list in the validation dialog. Create a named range for the list items and use that.

Do custom lists work on Mac Excel?

Yes, the steps are essentially the same, though the Options dialog may look slightly different. Look for Preferences > Custom Lists in some versions.

Related

• Shift Key Not Working on Mac? Fixes That Work
• Samsung Galaxy S26 Benchmark Results: How Fast
• Rising Interest Rates & AI Hardware Stocks