How To Create Drop Down List In Excel In 7 Easy Steps (2021)

How To Create Drop Down List In Excel In 7 Easy Steps (2021)

Are you looking for how to create drop down list in excel? There is no doubt excel is a powerful workbook or application, that not really help users to save numbers & data in spreadsheets form for future or office use.

In simple words excel is one of the most popular computer software programs used by almost every business to manage data & numbers in today’s time.

If you are one who has no idea how to create drop down list in excel, then you are coming to the right place here you find some step by step method on how to create drop down list in excel, so you have no problem in managing or creating data in excel.

Steps on How To Create Drop Down List In Excel:

1. Firstly open a new excel sheet and create a column in the spreadsheet.

 

2.After this now you have to select the cell where you want to make or create a drop down list.

How To Create Drop Down List In Excel

For example cell, C 3 has been selected.

 

3.After doing this now click over the data tab tools group and click carefully on data validation button.

Steps on How To Create Drop Down List In Excel

4.After clicking data validation, a dialog box will show or appear on the setting tab in the allow drop down list, now select the list option in the navigation.

How To Create Drop Down List In Excel In 7 Easy Steps (2021)

Also Read:  How to Open a Wine Bottle In 6 Easy Steps

5.After selecting the list option, now you see a source box, that specify the range that contains items on drop down list.

source box excel

6.After this if you want to see the drop down list, don’t forget to check in cell drop down column.

How To Create Drop Down List In Excel In 7 Easy Steps

7.After check in-cell drop-down column, now click OK. After this, you found that you have successfully created a drop down list in the selected cell.

Drop-down List

 

Also Read: How To Delete Instagram Account in 5 Easy Steps