Google Sheets is basically a free, collaborative version of Microsoft Excel.
And even though free usually means you can't do as much, Google Sheets does still allow you to add drop-down lists to your spreadsheets.
Here's how to do it.
How to add a drop-down list in Google Sheets
1. Open your Google Sheets project, or create a new one by going to sheets.new.
2. Select the cell, or cells, where you want to add a drop-down list.
3. Right-click into one of these cells.
4. Select "Data Validation."
5. Click into the "Criteria" section and select either "List from a range" or "List of items" and add your items, as appropriate.
6. Make sure that "Show dropdown list in cell" is ticked, and then click "Save."
After that, you should see a down-carrot appear within the cell, or cells, you specified.
When you click into that, you'll see the options you added — either a list from a range or a list of items — and you can then select from those options to set that cell.
Related coverage from How To Do Everything: Tech:
-
How to set a print area in Google Sheets, so you can print selected cells or sheets
-
How to share a Google Doc and customize its sharing settings
-
How to convert a Word document to a Google Doc on desktop or mobile
-
How to convert a PowerPoint to Google Slides in 2 different ways
-
How to make Google your homepage on any major web browser
