![]() How to Create a Yes/No Drop-Down List in Google SheetsĬreating a drop-down list in Google Sheets using Data Validation is very similar to how the list is created in Excel. Should you ignore the values in the drop-down list, and type a different value into the cell, an Error Alert message will appear. When you click in the first cell that has the Data Validation applied to it, the Input Message will appear. Click OK to add the Data Validation to the selected cells.Then type in a Title and Error message for the warning. Make sure that Show error alert after invalid data is entered is checked, and then select the Style in the drop-down list. Then select the Error Alert tab and set up a message when the user does not select from the valid drop-down list.Type in the Title and Input message required. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |