Excel is the spreadsheet tool of the Microsoft Office productivity suite.

How you open the Custom Lists editor will vary depending on your operating system and software version of Excel.

Then, click Excel Options, Popular, Top options for working with Excel, respectively.

You will see a list of all your lists in the Custom Lists editor.

Click NEW LIST at the top of the Custom lists box to create a new custom list.

This is the second box in the Custom Lists editor next to the Custom lists box.

Here, you can see all the list entries when you select a list from the Custom lists box.

If your new list is short, you can manually fill out the List entries box with entries.

This button lets you select a range of cells, such as a column or row, from your spreadsheets in order to use this data for your List entries.

This option could be useful for long lists with too many entries to manually enter.

In this case, close the dialogue box by clicking the red X button in the upper-left corner of the Custom Lists window.

The handle looks like a small, square dot in the lower-right corner of the cell.

It will automatically fill out your sheet with the rest of your custom list entries.

Open Microsoft Excel.

Launch the Custom Lists editor.

Select NEW LIST. 4.

Enter your list items under List entries.

Excel Choose List Item For Free By Whitelisting

Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

Excel For Mac Choose List Item