[Edit]

Google Sheets - how to create a drop-down list

1 contributors

2 contributions

0 discussions

0 points

Created by:

Lillie-Rose-Finnegan

489

In this article, we would like to show you how to create a drop-down list in Google Sheets.

1. Create a drop-down from a range

Edit

Create a drop-down from a range

Note:

If you enter data other than from the list, you can set Show warning or a Reject input option.

2. Create a drop-down from the list of items

Edit

Create a drop-down from the list of items

Note:

Items in the list are comma-separated.

Alternative titles

Show discussions ...

Donate to Dirask

Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!

Direct link

Join to our subscribers to be up to date with content, news and offers.

Google Sheets

Google Sheets - Authorization Required

Google Sheets - create new sheet by URL

Google Sheets - delete columns

Google Sheets - delete rows

Google Sheets - format if checkbox is selected

Google Sheets - group columns

Google Sheets - group rows

Google Sheets - how to add a custom menu list

Google Sheets - how to add checkbox

Google Sheets - how to copy a spreadsheet

Google Sheets - how to create a drop-down list

Google Sheets - how to freeze first column

Google Sheets - how to freeze first row

Google Sheets - how to hide columns

Google Sheets - how to hide rows

Google Sheets - how to hide sheets

Google Sheets - how to merge cells

Google Sheets - insert columns

Google Sheets - insert data into the last row with Apps Script (programmatically)

Google Sheets - insert rows

Google Sheets / Apps Script - handle GET requests

Google excel - prevent cells auto-changing when selected area is dragged

Native Advertising

🚀

Get your tech brand or product in front of software developers.

For more information Contact us

Dirask - we help you to

solve coding problems.

Ask question.

❤️💻 🙂

Join