Column Drop Down Excel. In a list or column copy values for dropdowns or write them down. In the cell we want to enter the validation we will select the cell i e cell b2 under data tab in the data tools section click on data validation.
An excel drop down list or dropdown menu can make it easier for the average microsoft excel user to enter data on a worksheet or workbook. In your sheet select the cells where you want the drop down list to appear. It means you can simply refer to a column within an excel table and the menu will automatically update based on the items in that list.
Just include the cells that should appear in the drop down.
On the settings tab in the allow box click list. Drop down lists make it easier and more efficient to enter data into your spreadsheets. How to add a drop down list to a spreadsheet column in excel. An excel drop down list or dropdown menu can make it easier for the average microsoft excel user to enter data on a worksheet or workbook.
