Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

adversecamber

macrumors regular
Original poster
Jul 9, 2008
159
0
I have a Numbers doc of my bank account. I can 'Sort and Filter' so that it displays only my monthly wage paid in by my employer.

But how can I then actually copy those 30 or so rows and then paste them into another new doc? If I select all and then copy/paste, it copies ALL rows - even those hidden after doing the search.

Any help?
 
Is it not highlight > copy (+C) > then paste (+V) in other document?

Edit: Highlight what you want to copy not select all like you have been doing.
 
I have a Numbers doc of my bank account. I can 'Sort and Filter' so that it displays only my monthly wage paid in by my employer.

But how can I then actually copy those 30 or so rows and then paste them into another new doc? If I select all and then copy/paste, it copies ALL rows - even those hidden after doing the search.

Any help?

You can Command-click to select just the rows you want & then copy & paste them. You will have to click each one individually.
 
Is it not highlight > copy (+C) > then paste (+V) in other document?

Edit: Highlight what you want to copy not select all like you have been doing.

If you re-read my original post, you'll see the problem.

If I have a doc of 150 rows and do a filter that then only shows (say) rows 3, 30, 45, 90 and 105 and then copy and paste, it will copy and paste ALL rows (1-150).
 
Can't you just hold CMD :)apple:) and click on (say) rows 3, 30, 45, 90 and 105 one by one and then copy + paste?
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.