If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...
To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need ...
I've got an Excel 97 worksheet in which I need to validate some cells. No problem, I'll just use Data->Validate, right? Wrong. The built in validation works well enough as long as the user doesn't ...