> ## 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: The One-Click Filter
- URL: https://www.jeffsu.org/productivity-ping-93/
- Published: 2023-05-19T01:00:33.000Z
- Updated: 2025-09-05T13:06:17.000Z
- Description: #93
- Author: Jeff
- Tags: #newsletter, Google Sheets

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

💡

Make a copy of [this Google Sheet](https://docs.google.com/spreadsheets/d/12LnR8wt%5FjFtaYU8-wF61XIYPypQezp-x4UgQ2qTMuNw/copy?ref=jeffsu.org) to follow along today’s Productivity tip

## **Simplifying Filters in Google Sheets**

Here’s how most people use Filter in Google Sheets:

- CMD or CTRL + A to highlight all the data
- Hit the "Create a Filter" icon to start the process

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

**Here’s how I filter in Google Sheets:**

- Right click on the cell with the value you want to filter for > Filter by cell value

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

💡

****Pro tip:** Check the bottom-right corner to instantly see how many rows your filter includes

## Bonus: Moving files just got easier in Google Drive

The “Move to” function in Google Drive used to be an **absolute nightmare**.

Now, you can simply click on the file path before moving a file or folder (like wtf took them so long):

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

## ⌨️ Keyboard shortcut

- CMD or CTRL + M in Google Sheets to comment on a cell

---

**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!