From here, you need to use the Edit Custom Lists option to start creating the list. In this article, we have explained the process of creating, deleting, and using a Custom List in Microsoft Excel.

Learn how to create date lists in Excel using autofill, formulas, and advanced techniques. Save time and boost efficiency with these tips ...

Learn how to make custom templates in Microsoft Excel to save you time and effort when creating similar reports or spreadsheet data analysis ...

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how.

Creating an Excel add-in is so useful and actually quite simple. It will allow you to use your custom functions in any workbook seamlessly.

Microsoft Excel's fill handle tool won't create an alphabetic list by default, but there are a few tricks you can use to make it work.

I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of your ...

How to Create a Drop-Down Box With Color. One way to streamline data entry is to create custom lists in Excel and use them to create drop-down lists in specified cells. When you use the program's ...

If you are routinely creating formulas that accomplish the same purpose, spending a little extra time upfront to create a function that can be reused will save you time in the end, possibly a ...

An curved arrow pointing right. Don't waste time typing the same formulas over and over again. Creating custom functions in Excel is easy to do. Produced by Sara Silverstein Follow BI Video: On ...