The data validation tool restricts data being entered and data already stored in the worksheet.

Name: The data validation tool restricts data being entered and data already stored in the worksheet.
Brand: Quizplus
Rating: 4.9 (49 reviews)

Question

Quizplus · Accepted Answer

The data validation tool in Excel is designed to restrict the type of data or the values that users enter into a cell, but it does not restrict or change data that is already stored in the worksheet unless those cells are edited after data validation rules are applied.

The Data Validation Tool Restricts Data Being Entered and Data