Learn how to turn on or off File validation in Word, Excel, and PowerPoint. Enable or disable it using Registry or Group Policy Editor.

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Data validation in Microsoft Excel is an incredibly useful feature that can help users control the type of data or the values that users enter into a cell. This feature can limit errors during data ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

Susan Harkins shows you a quick method for removing validation rules for multiple ranges in Excel, at the same time.

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 ...

I have a tracker. People putting lower case letters in codes is not cool, so I want to make it so my spreadsheet either rejects them, or better yet, corrects them. I've found the 'data validation' ...