Weekly Computer Tip # 68
29 May 2004

Finding cells that have data restrictions (Microsoft Excel)

In tip # 65 I explained how you can use data validation to create a drop-down list to ensure accurate data entry. The cell that has data restriction applied will only display its drop-down arrow when selected. However,

Did you know ...

In Microsoft Excel you can search the worksheet for every cell that has data validation applied.

Here's how:

1. Click anywhere on the worksheet.
2. On the Edit menu, click Go To.
3. Click Special.
4. Click Data validation.
5. Click All.

To see what the data restrictions are for a cell, click the cell, and then click Validation on the Data menu or check the drop-down list.

Until next week.

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer