Рет қаралды 98
Online course: Excel 365 for Busy People
www.udemy.com/...
Corporate training for Excel and other Microsoft and Adobe applications:
ComputerTrainin...
Between the Sheets, Episode 41: Drop-Down Lists and Data Validation in Google Sheets
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.