How to add drop down list in microsoft excel



Guide

  1. Click on the cell where you want the drop-down list.

  2. Click on the "Data" tab and select "Data Validation"

  3. In the dialog box, under Allow, choose "List."

  4. Add Your List Items under source.

  5. Select cells in Excel that already contain your list.

  6. Once added click on "OK."

  7. Your drop-down list will appear in the selected cell.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline