Find cells that have data validation

Microsoft Office Excel 2003

previous page next page

Find cells that have data validation

Find all cells with data validation

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

Find cells that match certain data validation settings

  1. Click a cell that has the data validation settings for which you want to find matches.
  2. On the Edit menu, click Go To.
  3. Click Special.
  4. Click Data validation.
  5. Click Same.
previous page start next page