Drop-Down Lists and Data Validation in Google Sheets

#excelhacks #exceltutorials #excelforbeginners
You can insert drop-down lists in cells in Google Sheets. It’s part of the Data Validation feature, where you establish rules for the type and values of data you can enter. It’s similar to the same feature in Excel. In this episode, we create drop-downs and look at other data validation options. We also create custom rules using the ISBETWEEN, AND, LEN, ISTEXT, and MOD functions.

About Bob:
Bob Flisser has been a software trainer since the mid-1990s, specializing in Microsoft and Adobe suites. He has written and recorded video courses for LinkedIn Learning, Pluralsight, Skillsoft, Tuts+, and others, and is the co-author of a dozen books of tips and shortcuts for Microsoft applications. He has also written magazine articles and training manuals and set up corporate training centers.

Connect with Bob:

Learn more about Experts Exchange:

#excelforbeginners #excelhacks #exceltutorials

[darkdiamond]

The dropdown used to allow you to delete the choice, which leaves the cell empty. It doesn't do that anymore??

[dougc]

In Google Sheets, the help text really doesn't get in the way. It only shows if the entry is invalid and could show the user what criteria needs to be met for the entry to be valid.