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.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Learn how to create, delete & use a Custom List in Excel. If your work requires typing specific lists repeatedly, you can create Custom Lists to save your time. Learn how!

On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders. That means you can add COPILOT to a formula and then use natural language in a ...

How to Create Pulldowns in Excel. You can create a pull-down menu in Microsoft Excel 2010 by configuring a list of values in the Data Validation menu. This function provides viewers of your ...

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

This article provides step-by-step instructions for color customizing your drop-down list in Microsoft Excel.