TechJunkie is a BOX20 Media Company
How to Make a Dropdown List in Google Sheets
Google Sheets is a free online version of Excel that is very useful for sharing, editing on the fly, and light spreadsheet work. Sheets work much the same as in Excel and look remarkably similar. This is good news for anyone more familiar with Excel and getting to grips with Google Sheets won’t take long at all. For example, if you want to make a dropdown list in Google Sheets and already know how to do it in Excel, the process is almost identical.
One of the more powerful spreadsheet tools is the dropdown box. You can turn a simple spreadsheet into an interactive questionnaire, customer feedback form, or whatever you like with dropdown boxes as they allow dynamic input from whoever you allow access to.
Create a Sheet containing whatever data you need it to include. Then:
As you can see, creating a dropdown list in Google Sheets is much easier than in Excel!
If you’re creating a customer-facing Sheet, it might be useful to create a second sheet that contains the data you want to include in the dropdown list. This keeps the main sheet clean and tidy and separates the user from the data as much as possible.
One of the great things about Google Sheets is the ability to customize your spreadsheet. For example; if something is urgent you can color code the cells in red. To do this with a dropdown follow these steps:
This menu also gives you a few other features such as; Bold, Italics, and Underlined text. You can also add another rule or choose a color scale if you’d like.
If you’d like to update the dropdown or delete it, you can follow these instructions:
Your Google Sheets may be an ever-evolving document so having this option makes it easy to update your dropdown lists.
Some users have experienced issues with the Google Sheets dropdown menus. There are various reasons for this. When you’re sharing a Google document with someone else there are a few rules and guidelines to ensure the recipient can interact with your dropdowns.
Google Sheets will not allow another person to interact with the document if it is in a “Read Only” status. This means they aren’t able to make any edits. To ensure others can use your dropdowns follow these instructions:
This is the most common issue with sharing Google Sheets. Performing this short series of steps should ensure that your recipients have full access to the document and its features.
More help for Google Sheets can be found on the Docs editors help website here.
Your email address will not be published. Required fields are marked *
Dec 20, 2020
944 Articles Published
Feb 22, 2024
Nov 18, 2023
Nov 14, 2023
Nov 7, 2023
Oct 28, 2023
Feb 24, 2024
Feb 23, 2024
May 31, 2021
Jan 15, 2020
Copyright @2024 TechJunkie