Home » Questions » Computers [ Ask a new question ]

iWork Numbers: how to copy only filtered values?

iWork Numbers: how to copy only filtered values?

I'm using Apple's iWork Numbers to look through some big spreadsheets of economic data. I used the Sort & Filter Panel to filter out just the rows of data I need, and now I'd like to copy just those rows into a new Numbers document. But I can't seem to figure out how to do that.

Asked by: Guest | Views: 21
Total answers/comments: 2
Guest [Entry]

"The Numbers manual (look for in on Apple's website, I just have the pdf with me on my desktop) states: When you sort table cells, values in hidden rows are taken into account.

And you can see this when you filter: the row numbers that correspond to your filter/sort appear, ignoring the row numbers that don't pass your filter/sort.

There is a solution for this. After filtering, hold down the return key to select the cells that you want. After selecting, hold command-c. Then deselect the table and press command-v to paste. This will create a table with the rows you selected and the empty rows. You can then sort the rows and delete the empty rows.

Note:
You have to be very precise about the cells you want. If you just drag across with the mouse you might accidently pick up the rows you don't care about.

Granted, this isn't the most elegant way, but from what I've seen of the documentation and my own experimentation, it's the only way...and it's a lot better than hunting through the spreadsheet yourself."
Guest [Entry]

"I found the most elegant (for myself) way to do this, hope this will help somebody:

Filter the original table
Select the first Row, hold ⇧ Shift, select the last Row
Copy (⌘+C)
Insert sheet (⇧+⌘+N) and delete empty table
Paste (⌘+V) | all filtered rows will be inserted as hidden and all filter criteria will be reset
Select any row → RMB (or ⌃+LMB) → Unhide All Rows | also highlights all the hidden
RMB (or ⌃+LMB) → Delete Selected Rows"