Web select the cells where you want to add the dropdown.

How to add options to drop down list in excel. Web everything until now works great now with all that information i would like. Web selected cells to add to drop down list. Web i have a table that contains staff names and days of month.

Web to insert a drop down list in excel, you use the data validation feature. Web on the data tab, in the sort & filter group, click advanced. Web if you set up your list source as an excel table, then all you need to do is add or remove.

Web to add an item, go to the last row in the column, press enter or return,. Select cell b3 to make it the active cell.