There are plenty of apps and websites available to keep you organized and on task, but for raw data power, nothing beats Microsoft Excel -- and for repetitive tasks, its drop-down lists are a real game-changer.

Whether you're juggling a side hustle, keeping tabs on family schedules, or just trying to make sense of a mountain of numbers, drop-down lists are a godsend that speed up typing. They can also cut down on typos and just keep everything looking neat. 

Also: How to use ChatGPT to write Excel formulas

Here's how to add them in Excel fast -- plus a few expert tips to tweak and style dropdowns to your liking.

How to add drop-down lists in Excel

What you'll need: You'll need a Microsoft 365 subscription to use Excel, whether you're on the web or the desktop app. I'm working from the desktop version here, so if your menu looks different online, Microsoft's support site can help you bridge the gaps. And yes, Google Sheets (and other tools) have dropdowns too, but the setup steps aren't exactly the same.

Can you edit a drop-down list after?

Absolutely. Just highlight the cells, go back to Data > Data Validation, and tweak the list of items in the Source box.

Also: How to use ChatGPT's Advanced Data Analysis to create quality charts and tables

Pro tip: If you have a longer list (or want to easily tweak your options later), you can type them into a column on another sheet and then point the Source field in the Data Validation pop-up to that range (e.g. =Sheet1!D1:D10).

Is there a limit to the number of items?

Excel lets you add over 30,000 options to drop-down lists -- but scrolling through that many choices is a real chore. If you have a huge list, try splitting it into categories or using multiple, smaller dropdowns so it's easier.

Want to create a yes/no dropdown?

Creating a yes/no drop-down in Excel uses the process we followed for the example above. Just change what you put in the Source field to say "Yes,No". 

1. Select the cells that you want to contain the drop-down lists.
2. Click on Data > Data Validation or Validation from the menu bar.
3. In the Settings tab of the Data Validation pop-up window, select List under Allow for your validation criteria.
4. Insert "Yes,No" in the Source field on the pop-up, separated by a comma only and no spaces.
5. Click OK in the Data Validation pop-up to save your yes/no drop-down list.

Can you add colors to dropdowns?

Yes. You can use Conditional Formatting to apply colors to cells. 

1. Create your drop-down list using Data Validation.
2. Select the cells containing the drop-down list.
3. Open Conditional Formatting by going to Home, then Conditional Formatting, and selecting New Rule.
4. Set a rule for a value by choosing "Format only cells that contain," entering a value, and assigning a color through Format and Fill.
5. Repeat the process for other drop-down options.
6. Click OK to save and apply the color-coding.

Is a formula needed to create dropdowns?

No. A formula is not needed to create drop-down lists in Excel. All you need to do is use the Data Validation menu.

Are dropdowns the same as data filtering?

People often mix up filtering with dropdowns, but they're not the same. Filters sit in your column headers so you can hide or show rows -- say by month, name, or location -- while drop-down lists live inside individual cells, letting you pick a value to enter.

Can you use Copilot to create dropdowns?

No, Copilot in Excel doesn't yet let you set up Data Validation drop-down lists directly via a prompt. You'll still need to use Excel's built-in Data Validation feature to insert those menus into your spreadsheet.

Get the morning's top stories in your inbox each day with ourTech Today newsletter.

Featured

I let Google's Jules AI agent into my code repo and it did four hours of work in an instant

I tried Google's XR glasses and they already beat my Meta Ray-Bans in 3 ways

6 things I did immediately after installing iOS 18.5 on my iPhone - and why you should too

Why WFH isn't dead and how digital-first companies have a big AI advantage

• I let Google's Jules AI agent into my code repo and it did four hours of work in an instant
• I tried Google's XR glasses and they already beat my Meta Ray-Bans in 3 ways
• 6 things I did immediately after installing iOS 18.5 on my iPhone - and why you should too
• Why WFH isn't dead and how digital-first companies have a big AI advantage