• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Google Sheets: Make Dropdown List

Google Sheets: Make Dropdown List

March 12, 2020 by Mel Hawthorne Leave a Comment

Google Sheets has a long list of useful features – there are dozens of things you can accomplish with them, not the least of which is the handy dropdown list feature. While cells are meant to hold one piece of info per cell, you can give yourself or other users a choice – by letting them choose from options stored in a dropdown.

To do so, open the sheet you would like to create your dropdown list in. Select the cell you want to add your list to. Then, click on the Data tab in your ribbon menu and select Data validation.

The data options

A new window will open. You have two main options to choose from – you can either create a list from an existing range of fields or enter the list items there. In the first case, you can select a range of fields in the format “Sheet1!A3:D3”. Alternatively, you can enter your own list items, separating them with commas.

The validation options

When you’re happy with that, you can add a few more functions. You can add validation options. This isn’t exclusive to dropdown lists and can be applied to any field. Validation checks to make sure if the data in the field matches the requirements.

Depending on your purposes, you can have the field reject unacceptable inputs, or even provide some help text that gives the users clues on what they should have put instead. When you are happy with your selection options, click the save button.

A complete dropdown list

Tip: If you put something other than the options in the list, you’ll see an error – the data validation option will inform you or your user that they’ve done something wrong even if you don’t set help text.

An example error message

To delete or edit your dropdown list, click on the field it is in again, and click on Data and then Data validation at the top. You can now make your edits. To delete it entirely, click on the remove validation button.

You Might Also Like

  • How to Make a Drop-Down List in Excel: 2 Best Methods in 2023
    How to Make a Drop-Down List in Excel: 2 Best Methods in…
  • Google Sheets: How to Use the Google Translate Formula
    Google Sheets: How to Use the Google Translate Formula
  • How to Convert Google Sheets to PDF
    How to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other Row
    Google Sheets: How to Shade Every Other Row
  • Troubleshooting Google Sheets Goes Blank
    Troubleshooting Google Sheets Goes Blank
  • Google Sheets Won't Let Me Type - Fix Guide
    Google Sheets Won't Let Me Type - Fix Guide

Filed Under: Internet

Reader Interactions

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • How to Update Steam Deck
  • Fixed Error Code: Out of Memory on Windows 11 Web Browsers
  • How to Play Minecraft on Chromebooks
  • Windows 11: How to Access and Use the Free Sound Recorder App
  • How to Enable Split-Screen in Microsoft Edge
  • How to Use Microsoft PowerToys in Windows 11/10
  • How to Turn Steam Deck Into Desktop PC
  • How to Use Google’s Magic Eraser on Android and iPhone

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

You May Also Like

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy