Control what is entered in an Excel cell- Data Validation

Please sign up for the course before starting the lesson.

The Data Validation tool is a great tool that allows you to control what gets put into a spreadsheet.

If for example we want to control what is input in cells A3 to A11 (red box) as we need the names to exactly match the spellings.

Data Validation

Data Validation

To see the full course contents click here.

Back to: Advanced Excel Course > Conditional Formatting