Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.

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.

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

You can create as many levels as you want, as long as you organize the named ranges well for seamless cascading. Make Excel Smarter With Dynamic Dropdown Lists: Here's How They Work ...

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

How to create an automated list of worksheet names in Excel -- and add a table of contents.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.

How to Make a List of Excel Data Into Data Separated by Comma. Microsoft Excel 2010 stores data within cells, which are simply segregated pieces of the spreadsheet that Excel can then reference to ...