A common use of data validation is to create a drop-down list. Use it to restrict the type of data that users enter into an Excel cell.

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.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.

To lock your cells in Microsoft Excel, you just need to head into the program's "Protection" tab. Locking a cell in Excel will make it so viewers can't change the data inside of that cell, which ...

If you would like to make sure that your Excel spreadsheet data is secure this guide will show you how to password protect and hide worksheets ...

Working with an Excel workbook that contains confidential information such as financial data, personal details, or trade secrets? Here's how you can protect the data in your Excel file from prying ...

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

You worked hard to put that Excel sheet together, now protect it from unintended damage.