• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Get Droid Tips

Get Droid Tips

Custom ROM | CyanogenMod | Android Apps | Firmware Update | MiUi | All Stock ROM | Lineage OS |

  • Android
  • Games
  • iPhones/iPad
  • Social Media
  • Windows
  • LineageOS 17.1
  • Android 10
  • iOS 14
  • Free Among Us for PC
  • Write for US
  • Watch IPL 2020 For Free
Home PC Tips and Tricks

How To Make A Dropdown List In Google Sheets

Updated on December 25, 2020 by Swayam Prakash

Advertisements

A dropdown list in Google Sheets allows people to select options that are already present. There will be a few options. They will show up when you click the dropdown icon. Then the user has to select any one option from that. In Google Sheets, it’s quite easy to create a dropdown list. I will show you in this guide how to do it.

Sometimes multiple people may be accessing or working on the same online spreadsheet. One may enter the wrong data and it may mess up the whole information of the sheet. So, with a drop-down list, it becomes simple to directly select from options that are already present.

Making A Dropdown List In Google Sheets

Here are the steps.

  • Launch Google Sheets
  • Then select the cells within which you wish to create the dropdown list
  • Click on Data by navigating to the menu bar
  • Under that select Data Validation
    create dropdown list in Google Sheets
  • Then in the dialog box under the Criteria tab choose between List From a Range and List of Items

Explaining List of Range and List of Items

Just to avoid confusion let me clarify between these two components. List of Range consists of values from a range of cells from one sheet that is to be used in another sheet. In the second worksheet when you click on the drop-down list, these values from the 1st worksheet will appear.

Advertisements

Secondly, in the List of Items, you can enter some values in text or number. In this option, you cannot put up data values from cells of another worksheet.

  • Now continuing the steps from the previous section let us select List of Items
  • Then put up some values separated by commas [let us create some even numbers in the drop-down list]
  • Tick the checkbox Show dropdown list in Cell
  • Enable the radio button for the Show Warning option. This means if someone enters an invalid value, a warning will show up
    Data validation for dropdown lists
  • If you select the Reject Input option, it won’t allow presenting information that’s not on the list
  • Enable the Show validation help text. This will help specify what values the user should choose
  • Let’s say for the above example you enter an odd number 3, then you will see the below message about the invalid value. It is invalid because the value must be something between 2,4,6 or 8 which are even.
    invalid value in dropdown list
  • Click Save
  • This is how the dropdown list will look. It is a drop-down list for putting up even numbers.
    dropdown list Google Sheets

Removing Validation

For removing any validation you have set,

  • Go to Data
  • Navigate and access Data Validation
  • Edit or remove the values that you have set up in the list of items
  • Click the Remove validation button to remove it

That’s it. This is all about how you can create a dropdown list in Google Sheets. I hope this guide was informative.

Read Next,

  • How to Disable Military Time in Google Sheets
  • How to Remove Google Sheets from Google Drive
  • Convert Google Sheets Into PDFs

Tagged With: Google Sheets

Primary Sidebar

Buying Guide

Top 6 Smartphones on Black Friday DealsĀ 

Best Motherboards for the AMD Ryzen 9 5900X

Best Power Supply Unit (PSU) For Nvidia RTX 3090, 3080, And 3070 GPU

Best 3D Mu6 Dummy Head Recording Earphone

Best Hidden Cams To Buy in 2020

60Hz vs 144Hz vs 240Hz Monitors – Differences and Purchase Guide

How To Use PayPal On Amazon To Shop Safely?

RTX 3070 vs 3080 vs 3090: Differences, Performance, Design, Price, and More

Geforce RTX 3080 and RTX 3090 Pre-Order Guide: Where To Buy in India

How Much Will it Cost in India for Nvidia GeForce RTX 3070 / 3080 / 3090?

Advertisements
Advertisements

Footer

Signal Private Messenger Alternatives for Android and iPhone

How to Change Android DNS Settings

Download Google Camera for Samsung Galaxy M12 [GCam APK]

How to Change Google Drive Backup and Sync Folder Location

How to Stop Signal From Telling You When Your Contacts Join

Download Google Camera for Oukitel C22 [GCam APK]

Download Latest Disney+ APK v1.11.3+ | Added All Language List

Fix: Cannot Delete Key: Error While Deleting Key on Windows 10

How to Fix Your Slow SSD on Windows 10

How to Recover PowerPoint Password on Windows 10

How to Switch Windows Hello Login method from PIN to Password?

Best CSV File Viewer Software for Windows 10

How to Disable Adobe Acrotray.exe from Startup

How to Use Microsoft’s PowerToys on Windows 10?

What is Doordash Error Code 400 and How to Fix It?

Why Does Zoom Error Code 3113 Appears and How to Fix?

Zoom Error 2011 | What This Error Code Mean and How To Fix it?

How to Find If Someone Deleted your Conversation on Snapchat

How to Activate Discovery Plus on TV

How to Cancel Fabletics VIP Membership

How to Get Discovery Plus for Free

© 2021 · Get Droid Tips

  • About Us
  • Contact Us
  • Privacy Policy
  • Disclaimer
  • Editorial Policy
  • Terms of Use
  • Write for Us