Find out how to Create a Dropdown Menu in Google Sheets

by DS | Mar 27, 2023 | Etcetera | 0 comments

Google has in recent years made it if truth be told easy to create a drop-down menu in Google Sheets and no longer the use of a system sought after. The dropdown menu means that you can create and customize a listing of belongings you’ll select/choose from.

In this post, I’m going to show you the right way to briefly add a dropdown menu in Google Sheets.

Table of Contents

Together with a dropdown menu on Google Sheets

There are two ways to insert a drop-down menu in Google Sheets. You’ll be capable of each do this:

#1

Make a choice the cell you want to create the dropdown menu.
Type @dropdowns and hit Enter.

#2

Or, you’ll add it from the Google Sheets menu.

Make a choice the cell to create the dropdown.
Make a choice Insert > Dropdown from the easiest menu.

Insert values in Dropdown menu

To enter your own worth, be sure “Dropdown” is selected in Requirements, and now not “Dropdown (from a wide range)“.

You’ll be capable of drag-drop to organize your items or even trade the colors of each products.

Dropdown Menu’s Advance Alternatives

There are a few additional problems you’ll do to customize your dropdown menu further.

Trade the display style

You’ll be capable of trade the menu’s display style. There are in recent years 3 alternatives to choose from, respectively, Chips (default), Arrow, and Easy text.

Chips

Arrow

Easy text

Display custom designed error message

Look under “if the ideas is invalid” – if “Show a warning” is checked, a tiny purple mark (top-right corner) could be displayed inside the cell when the patron input isn’t all the way through the provided alternatives.

And if “Reject the input” is checked, it will reject the entered products absolutely.

In any case, you’ll moreover create a custom designed message for the input error. To take a look at this, check “Show be in agreement text for a determined on cell” and enter your message.