If you don’t know about Data Validation in spreadsheets, this tool will blow your mind!
With Data Validation, you can make sure your users enter information into cells the right way. There are different options to use Data Validation, but the one we explore in the video is to create a drop-down menu for each cell.
In this tip, we’ll see …
- How to add data validation to cells in your spreadsheets
- How to make drop down menus for users to choose from
- How to easily make a dynamic list that populates drop down menus.
You can download the spreadsheet from this tip but I think you’ll get more out of the video this week.
Do you use Data Validation?
Join me next Thursday at 2pm for my next Farmer Spreadsheet Tip on Facebook Live.