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

    Joined:
    Jul 9, 2008
    #1
    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

    northy124

    Joined:
    Nov 18, 2007
    #2
    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

    DoFoT9

    Joined:
    Jun 11, 2007
    Location:
    Singapore
  4. PeggyD macrumors 6502a

    Joined:
    Jan 9, 2007
    Location:
    Covington, WA, USA
    #4
    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

    Joined:
    Jul 9, 2008
    #5
    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 regular

    Joined:
    Nov 27, 2007
    #6
    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