Data validation in Excel lets you restrict what can be entered into a cell, whether whole numbers, decimals, dates, or a certain number of characters. However, one of the most powerful capabilities of ...

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

Microsoft is still finding ways to inject drama into spreadsheets. The Verge points out that Microsoft is giving Excel support for custom live data types, expanding the content you can include well ...

Any program that doesn't do what you expect or let you make changes to something you should be able to edit is frustrating, and Excel is no exception. When it comes to Excel not permitting the ...