The same we will do for Week_Days and it will show likeĬlick Close and now select the cell where we need to add dropdown list. Here Name will be Month and in Refers to option enter the list under Month as shown below.

Select Formula>Name Manager in Defined names OR use shortcut Ctrl + F3 to open Name manager where we will keep lists of the array with their names so that we can call them by there name whenever required.Ĭlick New to create. Let’s understand this by taking an example.įirst, we need to create a dropdown list for the Main Category and then we will proceed to Sub_Category. To do this, we will use the Name manager and Data Validation.

In this article, we are going to learn how to edit dropdown list in excel.

It is essential to create drop-down lists or combo boxes that contain predefined options that limit user errors and allow for more consistent data entry. In this article, we will learn how to edit the dropdown option on cells.ĭata Validation is an Excel 2016 feature whose purpose is to restrict what users can input into a cell.

Insert a drop down menu in excel 2016