How To Create A Drop-Down List In Excel 365

It just makes sense to work as efficiently in your Excel worksheet as you can. One way to do that is using drop-down lists. Using a drop-down list will allow users to select an item from a list that you have created.

Follow the steps below to learn how:

  1. Open a new worksheet and key in the entries that you would like to appear in your drop-down list. You should have these items in an Excel table. If you do not, then you can convert your list to a table. Simply select any item in your list and press CTRL + T. The reason I say you should have your data in a table is that, as you add or remove data, any drop-downs you had based on that table will be automatically updated. So go ahead now and sort the data in your drop-down list.
  2. Select the cell in your worksheet where you would like to have your drop-down list.
  3. Click the Data tab on your Ribbon and Data Validation.
  4. Click Settings | Allow box | List.
  5. Click Source and select your list range.
  6. If you intend to allow your users to leave a cell empty, check Ignore blank.

Next up, I will tell you how to apply data validation to your cells. Be on the lookout!

1 thought on “How To Create A Drop-Down List In Excel 365”

  1. Thanks for that brief refresher course. Previously learnt this but never used it, so couldn’t remember how to do it when I needed it recently.

    Also, the importance of using a table instead of a range hasn’t fully impressed itself on me, but you just mentioned another good reason why.

    Much appreciated, Carol.

Comments are closed.

Exit mobile version


Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!