How to Create or Insert Dropdown List in Cells in Excel

With the help of drop-down lists, you may construct predefined alternatives for data entry, standardising and controlling input values is made simpler. Drop-down lists offer a practical approach to restrict options and guarantee precise data entry, whether you're managing data, conducting surveys, or designing forms.

We will walk you through the steps of generating and inserting a drop-down list in Excel in this article. Both the fundamental approach, which makes use of data validation, and the more sophisticated strategy, which makes use of named ranges in Excel, will be covered. You will have a firm grasp on how to successfully incorporate drop-down lists into your Excel spreadsheets by the end of this session. So, let's get going and discover how drop-down lists can improve your Excel experience!

Creating or Inserting Dropdown List in Excel Cells

Here we will first select the range of cells and create a drop-down list to complete the task. So let us see a simple process to know how you can create or insert drop-down lists in cells in Excel.

Step 1

Consider an Excel sheet where you have a list of items similar to the below image

First, select the range of cells where you want to create a drop-down list, then click on "Data Validation" under "Data”.

Select cells > Data > Data Validation.

Step 2

Then set allow to list and for source select the range of cells you want to display in the list, and click OK to complete the task.

Allow > Source > Ok.

This is how you can create or insert drop-down lists in cells in Excel.


In this tutorial, we have used a simple example to demonstrate how you can create or insert a drop-down list in cells in Excel to highlight a particular set of data.

Updated on: 12-Jul-2023


Kickstart Your Career

Get certified by completing the course

Get Started