FSA Tip #14 Data Validation

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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s