How to Make a Drop Down List in Microsoft Excel

How to Make a Drop Down List in Microsoft Excel

Drop-down lists are a convenient way to enter data, and that’s why we see them everywhere. Simply click on a field and a list of items will open for you to select. In Microsoft Excel, it is possible to create a drop down list and this is quite easy to do.

Watch our video tutorial where we show you how to create a drop down list in Microsoft Excel using Windows 10.

Video Transcript:

  1. How to Make a Drop Down List in Microsoft Excel
  2. Write all items that will be in the drop-down list
  3. Mark all the cells with the drop-down list items. Like in the video, give this group of items a name, and when you’re done press Enter on your keyboard. We will name it tutorial.
  4. Click on the cell where you want to create a drop-down list
  5. Click on Data
  6. Click on Data Validation
  7. Click on Data Validation…
  8. Open the drop-down list, then click on List
  9. Turn off the option Ignore blank
  10. In the Source field, type =, then the name you gave to the group. In our case this will be: =tutorial
  11. Click on OK


1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Share: Share to Facebook to Facebook Share to LinkedIn to LinkedIn Share to Twitter to Twitter

Send: Send to Viber to Viber Send to WhatsApp to WhatsApp Send to Telegram to Telegram Send to Facebook Messenger to Messenger Send to Email to Email

If you enjoyed this article, you might also like...

Leave a Reply

Your email address will not be published. Required fields are marked *