Data Validation to Reduce Time Checking Data

๐Ÿง  In this lecture, you've learned how to:

  • Limit cell input to whole numbers within a specific range
  • Customize alerts for incorrectly input values
  • Copy data validation to other cells
  • Create a dropdown list
  • Limit cell input to dates
  • Add tooltips with input instructions
  • Remove data validation.


๐Ÿ†• Dropdown lists in Excel for Microsoft 365 are now even better.

  • They automatically exclude duplicates.
  • They're searchable - start typing and the dropdown will narrow down to match your input.

๐Ÿ“บ See it in action.

Complete and Continue  
Discussion

80 comments