How to filter a table in Numbers on Mac: filter table rows step by step

What a filter does in Numbers on Mac

A filter in Numbers shows only the rows that match a rule you set. Every other row stays in the table, just out of view. You can change or remove the rule whenever you want.

Filters help most when a table gets long and you need one slice of it. Think of a list of orders where you only want one region. Or a task list where you only want the items that aren't finished. You set the rule once. Then the rows that match are all you see.

Check the table before you filter

Most filter problems start in the table, not in the filter. Do two checks before you add anything. Look for merged cells first. Then check that each cell's format matches what it holds.

Merged cells are a common cause of missing filter options. If the options don't appear, click the merged cell and choose Table > Unmerge Cells. To clear every merged cell in the table, select the table and choose Table > Unmerge All Cells. Apple's Mac guide describes both paths.

Format is the quieter problem. Apple's iCloud guide says filter results can look wrong when a cell's format doesn't match its contents. A number stored as Text is one example. Fix the format first, then add the rule. The rule then has clean data to work with.

Add a filter with the Organize sidebar

This is the method Apple's Mac guide walks through, and it works for any column. Every filter lives in the sidebar. Learn the Filter tab once, and the rest of this page is just choices inside it.

• Organize button: opens the sidebar that holds the Filter tab.
• Add a Filter: starts a new filter on the column you choose.
• Add a Rule: adds a second condition on the same column.
• Pop-up at the top of the Filter tab: sets All or Any when you have more than one filter.

Choose a filter type and rule

Numbers asks for a filter type once you pick a column. Apple's Mac guide uses Text as its example. Next you choose a rule, such as Starts with. Then type the value you want the rule to match.

Here is a worked example. Say one column is Status and another is Owner. Add a filter on Status with a rule that matches open items. Then click Add a Filter, choose Owner, and set the name you want. Numbers now applies both filters, and the next section explains how they combine.

Match all filters or any filter

When you have more than one filter, the pop-up at the top of the Filter tab decides how they work together. Choose all filters to keep rows that match every filter. Choose any filter to keep rows that match at least one. The Mac guide describes these same two behaviors.

• All filters: a row stays visible only if it passes every filter.
• Any filter: a row stays visible if it passes at least one filter.
• Status and Owner example with All: you see open items owned by one person.
• Status and Owner example with Any: you see every open item, plus everything that person owns.

Quick Filter for one column

Quick Filter is the fastest route when you only need one column. You don't open the sidebar at all. Move the pointer over the column letter, click the arrow that appears, and choose Quick Filter.

A checkbox list appears. Tick a value to show its rows, or untick it to hide them. For a large data set, Apple suggests choosing Show Selected. That keeps the view on the values you picked. When you finish, click anywhere on the sheet.

Newer versions made Quick Filter better. Numbers 11.2 arrived in October 2021 with a checkbox list that includes Search, Select All, and Deselect All. It also added Is Unique, Is a Duplicate, and Is Distinct as simple filter choices. If you use an older version, you may not see these.

Turn filters off or on in Numbers

Filters stay on until you turn them off. Press ⌥⌘F to turn all filters off without deleting them. Press it again to bring them back. Apple's shortcut list names this command Turn Filters on or off.

You can also delete one filter you no longer need. Delete filters you don't use so the Filter tab stays easy to read. Keep the ones you use often, since the shortcut brings them back in a single press.

If you can't get back to unfiltered data, you aren't the first. An Apple Community user asked this in February 2022. They were told to click the table, open the Organise button, go to the Filter tab, and turn off the filters.

Troubleshoot a filter that won't work

Start with what you can see. If the filter options are gray or missing, go back to the merged cell check above. If the sidebar has vanished, it is probably hidden. Press ⌥⌘I to show it again.

Menu names can differ by language and region. The Apple Community thread spells the button Organise, while Apple's guide uses Organize. If your label reads something else, look for the closest match on the sidebar controls.

Numbers for Mac versus Numbers for iCloud

The web version follows the same Filter tab idea with different labels. The iCloud guide uses Match Any Filter and Match All Filters in its pop-up. It asks you to press Return or Enter after you enter a value. It doesn't list any filter shortcuts.

The iCloud guide sets limits that the Mac guide doesn't spell out. Cells can't be merged while a table is filtered. Rules can't be applied to a table with cells merged across rows. With above average, below average, in the top, or in the bottom rules, you can't add rows while filtering. Apple documents this for iCloud, so don't assume the Mac app works the same way.

Which version of Numbers these steps cover

These steps follow Apple's Mac guide. The Mac App Store lists Numbers 15.4.2, and it requires macOS 26.0 or later. Apple's Creator Studio page lists Numbers 15.4 for Mac too. No Apple page names one version for these exact steps.

Apple Creator Studio launched on January 28, 2026. It costs $12.99 per month or $129 per year. Apple says Numbers stays free for all users, subscribers included. So you don't need a subscription to filter a table.

On April 13, 2026, Apple removed the old Pages, Keynote, and Numbers apps from the App Store. New downloads show only the Creator Studio compatible versions. To check your version, choose Numbers > About Numbers before you follow older guides.

Common mistakes with filters

Most filter mistakes are simple. The first is forgetting that the filter is still on. Rows go missing, and it looks like data loss. Check the Filter tab first, then press ⌥⌘F if filters are still on.

The second mistake is picking the wrong pop-up setting. If you want a narrow list, use all filters. Choosing any filter when you mean all brings back rows you wanted hidden. Read the pop-up before you trust the list.

The third mistake is changing merged cells while a filter is active. Apple's iCloud guide says cells cannot be merged while a table is filtered. Turn filters off before you merge or unmerge on the Mac too, to be safe.

Sort after you filter

Filtering decides which rows you see. Sorting decides their order. On the Mac, ⇧⌘R applies sorting rules, according to Apple's shortcut list. Use a filter to narrow the list, then sort what's left.

Where Lazur fits while you filter

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥⌘ to ask about anything on your screen. Lazur answers out loud. That helps when you're stuck in the Filter tab and can't see the next control.

Ask where something is, and Lazur draws a circle and a label around it. Ask how to do something, and Lazur guides you one click at a time, waiting for each click. Lazur doesn't click for you. You stay in control of Numbers the whole time.

Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they aren't stored. Content is never used to train AI models. Lazur runs on Mac with Apple silicon or Intel. Windows is planned, not available.

Next steps

• Open a practice table and add one filter on a text column.
• Press ⌥⌘F to turn filters off, then press it again to turn them back on.
• Use Quick Filter the next time you need a fast look at one column.
• Read Lazur for Numbers to see how pointing and guiding work inside Numbers 15.4.
• See the trial and plan details on the pricing page before you decide.