how do you insert a drop down menu in excel 2016

choose the list option from the drop down list. you will get the dialogue box which will show validation criteria. make sure to enter each drop down entry in a separate, consecutive cell in the same column. enter the list of values for your drop down in a column. you can find and double click a saved excel file on your computer, or open microsoft excel and create a new worksheet. open the excel spreadsheet file you want to edit.

if you decide you want to change the options in your drop down list, see add or remove items from a drop down list. for example, you might want to check to see if change the column width and row height to show all your entries. Right-click any cell in your source range, and select Insert from the dropdown menu.How To Create Drop Down List In Excel 2010 Examples And FormsĪfter you create your drop down list, make sure it works the way you want. Excel will dynamically update your range selection in the data validation settings to include the new range that you’ve increased by one cell.ġ. Instead, you’ll need to insert a new entry somewhere in the middle of the range. You won’t be able to add an item to the end of the range, because your range selection is limited by the first and last cells you’ve selected. In addition to changing items in your range to update your lists, you can also add new items. You can have the contents of a single range control the items for all of those lists, and it doesn’t matter how many there are.

This method is best when you want to format a lot of cells into a dropdown using the same list items. Any change you make there will update every dropdown list you created where you selected this range as the source.

The nice thing about this approach is that you can change any of the items in that list just by modifying any cell in the range.

How do you insert a drop down menu in excel 2016