> ## Content Index
> Fetch the complete content index at: https://www.jeffsu.org/llms.txt
> Use this file to discover other available public pages before exploring further.

# Google Sheets: Dropdowns made easy
- URL: https://www.jeffsu.org/productivity-ping-120/
- Published: 2023-09-22T01:00:23.000Z
- Updated: 2025-09-05T13:01:53.000Z
- Description: #120
- Author: Jeff
- Tags: #newsletter, Google Sheets

*(you can* [*filter previous issues*](https://www.jeffsu.org/filter-previous-editions-by-app/) *by application!)*

## Quick refresher on Data Validation

If I asked you to create a dropdown menu in Google Sheets right now, how would you go about it?

I’m willing to bet you’d do something like:

- Select cells > Data > Data Validation > Add Rule

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/09/CleanShot-2023-09-19-at-18.56.09.gif)

、

## Insert Dropdown in 2 clicks

A much easier way is:

- Type in the values first > Highlight cells > Right click > Dropdown

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/09/CleanShot-2023-09-19-at-19.01.13.gif)

💡

****Pro tip:** Select the bottom-most cell > Select remaining cells > CMD or CTRL + D to apply dropdown to remaining cells

---

**I’m always looking for ways to improve** so give me anonymous feedback [here](https://forms.gle/4Dscq21VYF3fjCcn8?ref=jeffsu.org) 📝

**Want someone to be more productive?** Let them subscribe [here](https://www.jeffsu.org/#/portal/signup) 😉

Thanks for being a subscriber, and have a great day!