Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

If I select the filtered rows and press -c it copies all of the data, including the stuff that's not visible due to the filter. I just want to copy the data that's visible, but I can't find a command to do that.

Does anybody know how?

share|improve this question

2 Answers 2

up vote 0 down vote accepted

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.

share|improve this answer

I do this using the following method:

  1. Filter the original table so that the rows you want are left visible and those that you don't are hidden.
  2. Select the whole table copy it (command + c).
  3. Create a blank table.
  4. Select the first cell (A1).
  5. Paste (command + v)

This puts only the visible cells into the blank table, expanding columns and rows if necessary.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.