How to Create a Drop‐Down on Google Sheets on PC or Mac

This wikiHow teaches you how to turn a cell into a drop-down menu in Google Sheets.

Steps

  1. Image titled Create a Drop‐Down on Google Sheets on PC or Mac Step 1
    1
    Create or open a spreadsheet in Google Sheets. If you don’t already have an existing spreadsheet open, here’s how to create a blank spreadsheet:
  2. Image titled Create a Drop‐Down on Google Sheets on PC or Mac Step 2
    2
    Click the cell where you want to add your drop-down menu.
    Advertisement
  3. Image titled Create a Drop‐Down on Google Sheets on PC or Mac Step 3
    3
    Click the Data menu. It’s at the top of the screen.
  4. Image titled Create a Drop‐Down on Google Sheets on PC or Mac Step 4
    4
    Click Data validation….
  5. Image titled Create a Drop‐Down on Google Sheets on PC or Mac Step 5
    5
    Select List of items from the “Criteria:” drop-down.
  6. Image titled Create a Drop‐Down on Google Sheets on PC or Mac Step 6
    6
    Enter the drop-down list menu items separated by commas. Each word or phrase will be a different option in the drop-down menu.
    • For example, if you type YES, NO, OTHER into the box, you will be able to select YES, NO, or OTHER from your drop-down menu.
  7. Image titled Create a Drop‐Down on Google Sheets on PC or Mac Step 7
    7
    Click Save. The selected cell now displays a drop-down menu. Click the menu to view the available options.
    Advertisement

You Might Also Like

Sign Out of Your Google Account on All Devices at Once
How to
Sign Out of Your Google Account on All Devices at Once
Turn Off Google Safesearch
How to
Turn Off Google Safesearch
Fix the "Google Play Store Has Stopped" Error
How to
Fix the "Google Play Store Has Stopped" Error
Write a Review on Google
How to
Write a Review on Google
Search by Image on Google
How to
Search by Image on Google
Buy a Google Play Gift Card Online on Android
How to
Buy a Google Play Gift Card Online on Android
Access Google Assistant
How to
Access Google Assistant
Restore Google Authenticator
How to
Restore Google Authenticator
Make a Google Account Without Gmail
How to
Make a Google Account Without Gmail
Get a Google Voice Phone Number
How to
Get a Google Voice Phone Number
Apply a Formula to an Entire Column on Google Sheets on PC or Mac
How to
Apply a Formula to an Entire Column on Google Sheets on PC or Mac
Create a Google Profile
How to
Create a Google Profile
Use Google Translate
How to
Use Google Translate
Sort by Number on Google Sheets on PC or Mac
How to
Sort by Number on Google Sheets on PC or Mac
Advertisement

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 5,033 times.
How helpful is this?
Co-authors: 3
Updated: May 25, 2021
Views: 5,033
Categories: Spreadsheets | Google Applications
Article SummaryX

1. Create or open a spreadsheet.
2. Click a cell.
3. Click Data.
4. Click Data validation…
5. Select List of items from the “Criteria” menu.
6. Type your drop-down menu items.
7. Click Save.

Did this summary help you?
Advertisement