# How to add a filter in Google Sheets on Mac to one range: step by step

> How to add a filter in Google Sheets on Mac: select your range, then go to Data > Create a filter. Hide rows by value, condition, or color.

URL: https://www.lazur.app/how-to/add-a-filter-to-a-range-in-google-sheets
Updated: 2026-11-06

To add a filter in Google Sheets on Mac, select the range of cells you want to filter, then go to Data > Create a filter. A filter icon then appears at the top of the range, and you use it to hide rows that don't match what you need.

## Quick answer

- Select the range in Google Sheets, including the row with your column names.
- Go to Data > Create a filter, or right-click the selection and choose Create a filter.
- Click the filter icon at the top of the range to hide rows by condition, value, or color.
- Remove the filter with Data > Remove filter. Your data stays where it is.

Applies to: Google Sheets in a web browser on macOS, with edit access to the file. Time: 3 min. Difficulty: Easy.

## What you need

- Edit access to the spreadsheet, so the filter becomes part of the file
- A header row with a column name above each column
- A range with no merged cells, hidden rows or columns, conditional formatting, or data validation
- Google Sheets open in a browser on your Mac

## How to Add a filter to a range in Google Sheets on Mac in Google Sheets on a Mac

1. **Open the spreadsheet in your browser.** Open the Google Sheets file in a browser on your Mac. Go to the sheet tab that holds the data you want to filter. Check that the column names sit in the first row of the block.
2. **Select the range with the column names.** Click the first cell in the block, on the row with the column names. Drag to the last cell in the last column you need. Check the highlight before you continue. Tip: Include every column you want to filter by. The filter covers only the range you select.
3. **Choose Create a filter from the Data menu.** (Data > Create a filter) Click Data in the menu bar at the top of the window. Choose Create a filter. A filter icon appears at the top of the selected range. Tip: If your menu wording differs, look for the word filter under Data.
4. **Or right-click the selected cells.** (Right-click the selected cells > Create a filter) Right-click inside the selected cells. Choose Create a filter from the list. You get the same filter icon as the menu route. Tip: Use this route when the mouse is already on the cells.
5. **Open the filter drop-down.** Click the filter icon at the top of a column. The drop-down offers filter by condition, filter by values, a search box, and filter by color. Tip: Use the search box first when a column holds many values.
6. **Hide the rows you do not need.** (Filter icon > Filter by values) Uncheck the values you want hidden. Click OK to apply the change. The rows that match stay visible, and the other rows are hidden, not deleted. Tip: Clicking OK applies the change, so click it every time you uncheck something.
7. **Turn the filter off when you finish.** (Data > Remove filter) Click Data, then Remove filter. You can also right-click any cell in the range and choose Remove filter. The hidden rows return. Tip: Removing the filter does not delete your data.

A filter in Google Sheets hides the rows that don't match a rule you choose. It does not delete anything. The rows stay in the file, and removing the filter brings them back. That makes a filter the safe way to look at part of a long list. You can filter by values you pick, by a rule you build, or by cell color. Google's Sheets product page lists phone, tablet, and desktop use. It does not mention a Mac app. So these steps assume you use Sheets in a web browser on your Mac.

## Before you select the range

![Person working at a laptop with a spreadsheet open, the kind of list where you add a filter in Google Sheets on Mac](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/add-a-filter-to-a-range-in-google-sheets/how-to-add-a-filter-in-google-1-530985.jpg)

Start with the column names. Put them in the top row of the block you plan to filter. The filter drop-downs appear on that top row, so clear names like Name, Region, or Status make them easy to read. If row 1 holds a report title, select from the row with the column names down to the last row of data instead.

Select the full block, not one column. The filter covers the range you select, so include every column you want to filter by. Click the first cell, then drag to the last cell. You can also click the first cell, hold Shift, and click the last one. Check the highlight before you move on, because the highlighted range is the range the filter uses.

## Create the filter from the menu or right-click

There are two routes, and both produce the same filter. The menu route is Data > Create a filter. Click Data in the menu bar at the top of the window, then click Create a filter. The right-click route suits people who already have the mouse on the cells. Right-click inside the selection and choose Create a filter from the list. Google's filter help page names both routes.

| Route | Where you click | What you see next |
| --- | --- | --- |
| Menu bar | Data > Create a filter | A filter icon appears at the top of the range |
| Right-click | Right-click the selection > Create a filter | The same filter icon appears |
| Remove it | Data > Remove filter | The icon goes away and hidden rows return |

_The three filter actions and what you should see after each one._

Google's help page does not show a Mac-only path, and I did not confirm any Mac-specific difference in the menu names. The labels here are the ones Google uses. If your menu wording differs a little, look for the word filter in the Data menu. Google can rename items, so trust what you see on screen over an older guide.

## Use the filter icon to hide rows

Once the filter is on, a small filter icon sits at the top of the range. Click it and a drop-down opens. The drop-down holds four tools. Each one hides or shows rows in a different way. Pick the tool that matches the question you are answering.

- Filter by condition: set a rule of your own, such as a text or number test.
- Filter by values: a list of every value in the column, each with a check box.
- Search box: type to find one value in a long list before you check it.
- Filter by color: show only the rows that match the colors you pick.

Here is a worked example. Say your sheet has a Region column with West, East, and North in it. Open the drop-down on Region, uncheck East and North, then click OK. Only the West rows stay visible. The other rows are hidden, not deleted, and the row numbers on the left skip over them. Check those row numbers before you copy or print, so you know what is visible.

## Turn the filter off without losing data

To turn the filter off, go to Data > Remove filter. You can also right-click any cell in the range and choose Remove filter. Either route clears the filter, and the hidden rows come back. Your values stay where they were typed.

A filter stays on until you remove it. Checking every box again in the drop-down does not turn it off. It only resets that one column. If you want the sheet to show everything, remove the filter.

## Sharing a filter with coworkers

A filter is part of the spreadsheet, not a private view. Google's help says that when you add a filter, anyone with access to the spreadsheet will find it too. If a colleague opens the file and sees rows missing, your filter is the likely reason. Check the filter state before you share the file, and remove it if they need every row.

View-only users can make their own temporary filter view. It is only for them, and Google's help says it is not saved. That lets viewers explore a list without changing the filter you set up.

## Limits to know before you filter a big sheet

Google Drive's help page says a Google Sheets spreadsheet can hold up to 20 million cells or 100MB. That limit covers the whole file, and a filter does not raise it. If your data is close to either limit, split it across files or tabs before you add a filter.

The Sheets API filter guide says a spreadsheet can have only one basic filter per sheet. The same guide says that filter applies to everyone who views the spreadsheet. If you need a second filter on the same tab, remove the first one, or look into filter views, covered briefly below.

- **20 million** cells allowed in a Google Sheets spreadsheet, per Google's file limits ([source](https://support.google.com/drive/answer/37603?hl=en))
- **1** basic filter allowed per sheet in Google Sheets ([source](https://developers.google.com/workspace/sheets/api/guides/filters))

## Keyboard shortcuts for filters on Mac

Google's keyboard shortcut page lists one filter key for Mac. Ctrl + Cmd + R, written ⌃ ⌘ R, opens the drop-down on a filtered cell. The page has no row for creating a filter or switching one on and off. Use the Data menu for those tasks, and use ⌃ ⌘ R once a filter is already on.

Older guides mention ⌘ ⇧ L as a filter toggle. The Bricks guide, dated Feb 20, 2025, gives that key. Google's shortcut page does not list it, and the guide does not say whether it needs an extension. Test it in your own sheet before you rely on it, and keep the Data menu as your backup.

## Why Create a filter is greyed out or missing

![Mac laptop on a desk beside notes, a typical setup for working in Google Sheets on Mac](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/add-a-filter-to-a-range-in-google-sheets/how-to-add-a-filter-in-google-2-17a13a.jpg)

Sheets blocks a filter on some ranges. Google's help page names four causes. Check each one in the range you selected, then try again.

- Merged cells: unmerge the cells in the range, then select the range again.
- Hidden rows or columns: unhide them, then select the full range again.
- Conditional formatting: remove or change the rule on the cells in the range.
- Data validation: remove the validation rule from the cells in the range.

Most fixes for a greyed-out menu come from third-party posts that are more than two years old. Use them as starting points. Google's help page is the reference, and it lists the causes without a full fix.

## Common mistakes and how to fix them

The first mistake is expecting the filter to cover data you did not select. The filter covers the range you chose when you created it. Select every column first. If you missed one, remove the filter, select the full range, and create it again.

The second mistake is trying to add a second basic filter to the same sheet. A sheet holds one basic filter. Remove the first filter before you add another, or use filter views for a second saved view.

## What this guide leaves out

This guide covers the basic filter on one range. It leaves out filter views in depth. I did not find an official Google help article on them, and third-party menu paths disagree. Google's Sheets API guide says a sheet can save several filter views, but only one can be applied at a time. It also says a basic filter and a filter view cannot be applied to the same data range at once.

## Next steps after you add the filter

A filter works best when the column names stay on screen. Freeze the top row so the headers remain visible while you scroll through filtered results. The steps are in [How to freeze the top row in Google Sheets on Mac](https://www.lazur.app/how-to/freeze-the-top-row-in-google-sheets).

If you filter to answer a question across many rows, a pivot table may fit better. The [Google Sheets guide for data analysts on Mac](https://www.lazur.app/for/data-analysts/google-sheets) covers clean-up and pivots. Filters show rows. Pivots summarize them.

![Person reviewing a data table on a computer screen, where a filter in Google Sheets on Mac saves scrolling](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/add-a-filter-to-a-range-in-google-sheets/how-to-add-a-filter-in-google-3-8a9dc2.jpg)

## Shortcuts

- Open the drop-down on a filtered cell: ⌃ ⌘ R

## If it does not work

- **Create a filter is greyed out** Check the selected range for merged cells, hidden rows or columns, conditional formatting, and data validation. Fix each one you find, select the range again, and retry.
- **I cannot add a second filter to the sheet** A sheet holds one basic filter. Remove the existing one with Data > Remove filter, then create the new one. Filter views can give you a second saved view.
- **A coworker sees filtered rows I did not expect** The filter is shared with anyone who has access to the file. If they need every row, remove the filter with Data > Remove filter.
- **The Command Shift L shortcut does nothing** That key comes from a third-party guide, and Google's shortcut page does not list it. Use Data > Create a filter or the right-click route instead.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where's the Create a filter option?”: Lazur draws a circle and a label around Create a filter on your screen. It points and explains. It does not click for you. (Points at it)

## FAQ

### Can I add a filter in Google Sheets on Mac with the keyboard only?

Google's keyboard shortcut page lists no shortcut that creates a filter. Use the Data menu with a trackpad or mouse. The only filter key the page lists is ⌃ ⌘ R, which opens the drop-down on a cell that is already filtered.

### Why is Create a filter greyed out in my sheet?

Google's help page names four causes: merged cells, hidden rows or columns, conditional formatting, and data validation rules. Check the selected range for each one. Fix the one that applies, then select the range again and retry.

### Will a filter delete rows I cannot see?

No. A filter hides rows and does not delete them. Unchecking values in the drop-down hides those rows. Data > Remove filter brings them back.

### Can my coworkers see my filter?

Yes. Google's help says anyone with access to the spreadsheet will find the filter too. View-only users can create a temporary filter view that only they can use, and it is not saved.

### Can I have two filters on one sheet?

Not as basic filters. The Sheets API guide says a spreadsheet can have one basic filter per sheet. A sheet can save several filter views, but only one can be applied at a time.

### Is there a Google Sheets app for Mac?

Google's Sheets product page lists phone, tablet, and desktop use, but it does not mention a Mac app. The steps on this page assume you use Sheets in a web browser on your Mac.

### What does Filter by color do?

It limits the visible rows in that column to the cell colors you choose. Use it when your team marks rows with colors and you want to see only one group.

## Sources

1. [Filter and sort data in Google Sheets (Google Docs Editors Help)](https://support.google.com/docs/answer/3540681?hl=en), Google, checked 2026-11-07
2. [Keyboard shortcuts for Google Sheets (Google Docs Editors Help)](https://support.google.com/docs/answer/181110?hl=en), Google, checked 2026-11-07
3. [Manage data visibility with filters (Google for Developers)](https://developers.google.com/workspace/sheets/api/guides/filters), Google for Developers, checked 2026-11-07
4. [Google Sheets (Google Workspace)](https://workspace.google.com/products/sheets/), Google, checked 2026-11-07
5. [Google Drive and Google Workspace file limits](https://support.google.com/drive/answer/37603?hl=en), Google, checked 2026-11-07
6. [How to Filter in Google Sheets Using a Shortcut](https://www.thebricks.com/resources/guide-how-to-filter-in-google-sheets-shortcut), The Bricks, checked 2026-11-07