๐ง 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.
80 comments