If the user does the drop-down and selects, no problem. These cells will now also be moderated/normalized by data validation, so you will only be allowed to enter one of the source options into the cell. Now all of the cells you initially chose will have a dropdown menu function with a list you can choose from for the cell. The second is the Error Alert, this will let you set up a message when someone attempts to input information in the cell that does not match what you put in the source. The first one is Input Message this tab will allow you to assign a small pop-up message that appears whenever someone selects a cell with this data validation assigned to it. There are two additional Data Validation tabs that you can use if you like.
If you already have a few rows with your List data, you can just select those fields.In the Source box, there are two different options. Now that you have the desired cells selected click the Data tab in the ribbon and then click the Data Validation tool.įrom the Settings Tab, Click the Allow drop-down list and click List. Select which cells to add validation toĬlick a column to highlight the entire column. In the example below, I’m going to build a drop-down to an entire column to help me build out the Genre category of my music collection. Data Validation ExcelĪlthough I normally add Data Validation drop-down lists to entire columns, you can also add the drop-down to individual cells. For instructions for modern versions of Excel, read our article: How to Create Drop-Down Lists Using Data Validation in Microsoft Excel.
Update: This article is for Excel 2007 & 2010.
0 kommentar(er)
