You can use a drop-down list of choices in a single cell. In this video, learn how to add and remove data validation to a cell.
- [Instructor] You can provide a menu of choices … via a dropdown list in a single cell. … I've already created a name range for these cities. … Let's add this list to a cell. … Select your cell and click Data, and then Data validation, … In the Criteria I'll start by choosing a List from a range. … Now I can type my named range. … Make sure Show dropdown lists in cell … has a check mark next to it. … Then click Save. … Now I can click the down arrow … and choose from a list of values. … I can also add choices directly. … Let's do this one more time. … This time I'm going to type a list of items. … I can enter my items separated by a comma. … Again, make sure Show dropdown list in cell … has a check mark and then click Save. … I have the same list, … except I type them in … instead of using an existing named range. … To view these choices or to remove the validation, … select your cell, click Data, Data validation, … and choose Remove validation. … The value remains in place … and you can hit the Delete key on your keyboard …
- Wrapping text
- Collaborating with others on a spreadsheet
- Freezing and locking panes
- Auto-filling data quickly
- Rotating cell data
- Formatting spreadsheets
- Protecting sheets
- Inserting links
- Filtering views
- Undoing unwanted changes
Skill Level Intermediate
1. Google Sheets Quick Tips
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.