Web everything until now works great now with all that information i would like.

How to add options to drop down list in excel. Web select the cells where you want to add the dropdown. Web if you set up your list source as an excel table, then all you need to do is add or remove. Web you aim to add a dropdown list where each item appears just once.

Select the range of cells, and. Select cell b3 to make it the active cell. Web i have a table that contains staff names and days of month.

Web to add an item, go to the last row in the column, press enter or return,. Web selected cells to add to drop down list.