From the course: Excel: Avoiding Common Mistakes (Microsoft 365)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Restrict data using validation constraints
From the course: Excel: Avoiding Common Mistakes (Microsoft 365)
Restrict data using validation constraints
- [Instructor] We can avoid lots of errors to this worksheet by using a feature called Data Validation to make sure that the data in column A as the descriptor below it says, "Must be exactly 6 characters long for each entry." And column B, you see the description there for the salaries. And in column C, limitations. We do this by way of Data Validation, perhaps the strongest tool in Excel to control what goes into a worksheet. Most often you'll be using an entire column, particularly if you envision a list that's going to grow and grow and grow. We want every cell in column A to have the same validation rule, so let's select column A. And Data Validation is found on the Data tab in the ribbon in the Data Tools group. And depending upon your display, you might see the phrase Data Validation, you might see a larger icon, but here it is right here. "Pick from a list of rules to limit the type of data." Hit the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.