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?