how do you fix the drop down menu in excel 2016

There is another problem too, and it is not just an annoyance. So that’s the first problem caused by blank cells in the data validation source list - if there’s a blank cell in the source list, and the cell with the data validation list is blank, the list will open with the matching blank entry selected. Cell D4 is blank, so the list finds the first matching entry in the Products list - a blank row at the end of the list.In cell D3, Pencils was previously selected, and the list opens to Pencils.

When a data validation drop down list opens, it tries to match whatever is currently in the cell. This might seem like a good idea when you’re setting up a list, but it causes problems with the data validation drop down lists. The person who set up the list left a few blank cells at the end, where new items could be added. In this example, the drop down list is based on a range named Products. Why does this happen, and how can you prevent it? That can be annoying if you have to scroll all the way back up to the top of a long list, where you have the put the most popular items. When you click the arrow to open the drop down list, the selection goes to a blank at the bottom of the list, instead of the first item in the list. Cell D4 has a drop down list, created with Excel Data Validation. Here’s a screen shot that shows the problem. Sometimes the Excel drop down opens at end of the list, instead of the top. Then, instead of typing a product name in an order list, you can select a valid product name from the list. To make data entry easier, you can create a drop down list of items in a worksheet cell.

How do you fix the drop down menu in excel 2016