Find cells that have data validation rules

Do any of the following:

Find all cells with data validation

  1. On the Edit menu, click Go To.

  2. Click Special.

  3. Select Data Validation, and then select All.

  4. Click OK.

    The cells that contain data validation are selected.

Find cells that have the same validation rules as another cell

  1. Select a cell that has the data validation you want to find.

  2. On the Edit menu, click Go To.

  3. Click Special.

  4. Select Data Validation, and then select Same.

  5. Click OK.

    The cells that contain the same data validation as the chosen cell are selected.

See also

Apply data validation to cells

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×