Apply data validation to cells - Microsoft Support
Use data validation rules to control the type of data or the values that users enter into a cell. One example of validation is a drop-down list (also called a drop-down box or drop-down menu). …
More on data validation - Microsoft Support
Use these tips and tricks for working with data validation in Excel. Note: If you want to use data validation with workbooks in Excel Services or the Excel Web App you will need to create the …
Add, change, or remove data validation - Microsoft Support
By adding data validation to controls in your form template, you can ensure that the data that you collect is accurate and consistent, and that it conforms to any standards that are already in use …
Find cells that have data validation rules - Microsoft Support
You can find cells in a workbook that contain data validation by using the Go To Special dialog box. On the Edit menu, point to Find, and then click Go To. Click Special. Select Data …
Create a drop-down list - Microsoft Support
Download Excel data validation examples. Data entry is quicker and more accurate when you restrict values in a cell to choices from a drop-down list. Start by making a list of valid entries …
Display or hide circles around invalid data - Microsoft Support
On the Data tab, in the Data Tools group, click the arrow next to Data Validation, and then click Circle Invalid Data. Excel displays a red circle around any cells that contain invalid data.
INDIRECT function - Microsoft Support
How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.
Restrict data input by using validation rules - Microsoft Support
You can vet or validate data in Access desktop databases as you enter it by using validation rules. You can use the expression builder to help you format the rule correctly. Validation rules can …
Add or remove items from a drop-down list - Microsoft Support
Go to Data > Data Validation. On the Settings tab, click in the Source box, and then on the worksheet that has the entries for your drop-down list, Select cell contents in Excel containing …
Introduction to What-If Analysis - Microsoft Support
By using what-if analysis tools in Microsoft Office Excel, you can use several different sets of values in one or more formulas to explore all the various results.