Pick From Drop Down List Excel. Select the cell or range of cells where you want the drop down list to appear c2 in this example. If you have multiple cells with drop down lists that you want to delete you can use ctrl left click to select them.
On the settings tab in the allow box click list. Go to data data tools data validation. Alt down arrow shortcut.
Select a cell or a range you want to force users to select data from a list and click data data validation.
Go to the data tab on the ribbon then click data validation. Choose list option is allow and select the cells for main category names which in this case is at b2 and c2 cell month and week days as we can see a drop down list is created which asks the user to choose from the given option. Alt down arrow shortcut. Go to data data tools data validation.
