Cell Drop Down Excel. When we click on ok we have a drop down in cell b2. Similarly you can enter the items in a single row such as a1 d1.
If you already made a table with the drop down entries click in the source box and then click and drag the cells that contain those entries. It s easy to add a drop down list to a cell in excel but the process is not intuitive. In the data validation dialogue box within the settings tab select list as validation criteria.
Copy the validation to all the cells up to cell b6.
You can find and double click a saved excel file on your computer or open microsoft excel and create a new worksheet step 2 enter the list of values for your drop down in a column. This will bring below the data validation window. Drop down lists are created using the data validation feature. Go to the worksheet or area of your current worksheet where your list items are and then add or delete the desired item.
