Numbers - How do I select certain rows?

[adversecamber]

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?

 

[northy124]

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.

 

[DoFoT9]

click n' drag still around these days??

 

[PeggyD]

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.

 

[adversecamber]

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).

 

[oldtime]

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?