Home > Support > Hints and Tips > Tip of the Week

Weekly Computer Tip # 68
29 May 2004

Start each week with a free tip

To subscribe, please type your email address in the box below:

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.

Email this page to a friend

Enter recipient's email address in the box below:

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  

© Roem Ltd. All Rights Reserved
May 2004