Data Validation Drop Down In Excel. However do not include the header cell. Select a range or cells which you want to restrict or add data validation.
At this point there are a few ways that you can tell excel what items you want to include in your drop down list. On the source click on range selection button select your list range click ok. The data validation window will appear.
If you are a fan of a shortcut key instead of going through the above steps you simply press the shortcut excel key alt a v v to open the above data validation window.
I m going through data validation allowing list and then i want to have it so that i can type y or n meaning yes or no without having to use capitals necessarily. Popular course in this category. On the source click on range selection button select your list range click ok. To specify how you want to handle blank null values select or clear the ignore blank check box.
