How can i copy filtered rows in Numbers to a new table?

Question

Level 1

9 points

How can i copy filtered rows in Numbers to a new table?

So I like to import my business bank balance into Numbers where I can do all kinds of fancy things.

I really like the new-ish Filter option so I can , e.g, show only rows containing certain text.

This makes it easy to make a report on transactions to/from a particular entity.

The most obvious thing to do then, is copy those rows (and only those rows) to a new table where I can manipulate, format, and do even more fancy things without the other 1000s of rows.

So is there really no way to copy those rows into a new table all at once? (one by one suggestions wont work for me, there's just too many rows for that to be practical)

Posted on Jun 24, 2025 7:06 PM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,532 points

Jun 24, 2025 8:32 PM in response to BrotherKz

The filter function is powerful. To copy the results of a filter to another table:

First have a destination table ready.

Then:

Select the visible cells in the filtered table
Command-c to or Edit > Copy to copy
Click once in a cell of the destination table
Command-v or Edit > Paste and Match Style to paste.

SG

Reply

Answer 2

SGIII

Level 8

37,532 points

Jun 25, 2025 8:24 AM in response to BrotherKz

BrotherKz wrote:

Amazing! It does work with those specifics.

I've been mislead by answers from elsewhere.

The key specifics are to have a destination table ready set up and click a cell just once before pasting into it.

The FILTER function, just added to Numbers, is a formula-based approach. You could also copy-paste from its results.

For your purposes, though, filtering through the built-in interface functionality is probably quicker and easier.

SG

Reply

Answer 3

Badunit

Level 7

30,342 points

Jun 25, 2025 7:43 AM in response to BrotherKz

BrotherKz wrote:

I've been mislead by answers from elsewhere.

FILTER is a new function in Numbers. Most answers will be about how to do it some other (much more difficult) way. There are 15 years worth of those other answers.

Reply

Answer 4

BrotherKz Author

Level 1

9 points

Jun 24, 2025 9:43 PM in response to SGIII

Amazing! It does work with those specifics.

I've been mislead by answers from elsewhere.

Thanks.

Reply