Learn how to Create a Dropdown Menu in Google Sheets | 3waytraffic
HomeInternetLearn how to Create a Dropdown Menu in Google Sheets

Learn how to Create a Dropdown Menu in Google Sheets

Google has lately made it very easy to create a drop-down menu in Google Sheets with no formulation wanted. The dropdown menu permits you to create and customise an inventory of things you’ll be able to choose/select from.

On this publish, I’m going to indicate you the best way to shortly add a dropdown menu in Google Sheets.

Including a dropdown menu on Google Sheets

There are two methods to insert a drop-down menu in Google Sheets. You may both do that:

  1. Choose the cell you need to create the dropdown menu.
  2. Kind @dropdowns and hit Enter.

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

  1. Choose the cell to create the dropdown.
  2. Choose Insert > Dropdown from the highest menu.
Insert values in Dropdown menu

To enter your individual worth, be sure that “Dropdown” is chosen in Standards, and never “Dropdown (from a spread)“.

You may drag-drop to rearrange your objects and even change the colours of every merchandise.

Dropdown Menu’s Advance Choices

There are a couple of extra issues you are able to do to customise your dropdown menu additional.

Change the show model

You may change the menu’s show model. There are at present 3 choices to select from, respectively, Chips (default), Arrow, and Plain textual content.



Plain textual content

Show customized error message

Look beneath “if the information is invalid” – if “Present a warning” is checked, a tiny pink mark (top-right nook) might be displayed within the cell when the consumer enter just isn’t inside the supplied choices.

And if “Reject the enter” is checked, it is going to reject the entered merchandise completely.

Lastly, you too can create a customized message for the enter error. To do that, test “Present assist textual content for a specific cell” and enter your message.


Popular posts