How to Create a Drop Down List in Excel

How to create a drop-down list in Excel? In this tutorial, I show you how to easily create a drop down list in Microsoft Excel. This means you can add a drop down list to your spreadsheet with any options you want. Drop-down list are perfect for pre-defined answers that makes it easy to quickly select an option.

Create a Drop Down List in Excel(Video Tutorial):

Follow the steps below to create a drop down list in Excel:

  1. Open Excel on your Windows 10 computer or Mac.
  2. Create a table containing the answers you want to include in your drop down list.
  3. In the top menu of Excel make sure you are on the Data ribbon.
  4. In the Data ribbon, select Data Validation.
  5. In the Data Validation window under the Settings tab find the Allow drop-down menu and select List.
  6. Then click the empty text box and highlight the table containing the items you want in your drop down list.
  7. Select OK.

More Excel Tips & Tutorials:

You may also like

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.