How to restrict user input in Excel: Part 6—Excel MVP Secrets with Miss Excel

Collaborating in Excel is great, but when there are no barriers, things can get out of hand.

Data validation is used to restrict user input, so entries adhere to specific criteria, helping to maintain the data’s overall quality.

Excel provides a range of options for this. By going to Data ➤ Data Validation, you can set a cell(s) to only accept whole numbers, text, or dates, for example.

You can also set up a predefined list to really narrow the boundaries.

In the final episode of a six-part series, Kat Norton, aka Miss Excel, demonstrates how to do this in her order report example.

She also uses conditional formatting to serve as a visual aid, so the choices are clearly distinguishable.

If you haven’t watched the previous episodes, be sure to catch up on them so you can learn about other ways to become more efficient in Excel!

#excel #microsoftexcel #globalexcelsummit

The Global Excel Summit is the world's largest virtual gathering of Microsoft Excel users and experts.

Find us on:

Get ready to Excel Beyond Expectation.