Numbers - How do I select certain rows?

Discussion in 'Mac Apps and Mac App Store' started by adversecamber, Jul 27, 2008.

  1. adversecamber macrumors regular

    Jul 9, 2008
    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?
  2. northy124 macrumors 68020


    Nov 18, 2007
    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.
  3. DoFoT9 macrumors P6


    Jun 11, 2007
  4. PeggyD macrumors 6502a

    Jan 9, 2007
    Covington, WA, USA
    You can Command-click to select just the rows you want & then copy & paste them. You will have to click each one individually.
  5. adversecamber thread starter macrumors regular

    Jul 9, 2008
    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).
  6. oldtime macrumors 6502

    Nov 27, 2007
    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?

Share This Page