If you want to validate a cell to restrict data entry to a date range then follow these steps:
Select the cell you want to validate.
On the Data tab, in the Data Tools group, click Data Validation.
The Data Validation dialog box will open.
In the Data Validation dialog box, click the Settings tab.
Click on the Allow box [...]
To find cells that meet a specific criteria, for example cells with conditional formatting or cells which have data validation, proceed as follows:
In the Home tab Editing group click Find and Select.
Click on:
Formulas : to find cells that contain formulas.
Comments : to find cells that contain comments.
Conditional Formatting : to find cells that have [...]
If you want to validate a cell to restrict data entry to values in a drop-down list follow these steps:
Select the cell you want to validate.
On the Data tab, in the Data Tools group, click Data Validation.
The Data Validation dialog box will open.
In the Data Validation dialog box, click the Settings tab.
Click on the Allow [...]
Microsoft Excel cannot check spelling automatically as you type as you see in Microsoft Word for example. However you can check spelling all at once by selecting so from the Tools menu.
When you check spelling, Excel checks the entire active worksheet, including cell values, cell comments, embedded charts, text boxes, buttons, and headers and footers. [...]
If you want to find cells in your worksheet that have data validation, then follow these steps:
1. On the Edit menu, click Go To. The Go To window will open.
2. Click Special. The Go To Special window will open.
3. Click Data validation.
4. At the bottom of the window click on the radio button that says [...]
In a previous post I explained how to validate a cell using a fixed range of data. In this post we will see how to validate a cell based on the value of another cell.
Suppose we have a list of documents each with issue date and expiry date. We want to validate the expiry date [...]
If you are designing an excel sheet for other users to enter data, or even for your own use, it is a good idea to use the data validation feature to insure that only correct data will be entered. hear is how you do it:
Select the cell you want to validate.
On the Data [...]
