Excel Tips & Tricks: More Data Validation

Here is more information on Data Validation in Excel—which can be used to create cells with a controlled vocabulary. This eliminates typing errors and allows for easier filtering and searching.

Here's an earlier example of this tip.

Thanks to Katie Lake from the MRP team for providing content for this Excel tip!