Numbers - How do I select certain rows?

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

Most Liked Posts
  1. adversecamber, Jul 27, 2008

    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?
     
    share
    + Quote Reply
  2. northy124, Jul 27, 2008

    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.
     
    share
    + Quote Reply
  3. DoFoT9, Jul 27, 2008

    DoFoT9 macrumors P6

    DoFoT9

    Joined:
    Jun 11, 2007
    Location:
    Singapore
    #3
    click n' drag still around these days??
     
    share
    + Quote Reply
  4. PeggyD, Jul 27, 2008

    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.
     
    share
    + Quote Reply
  5. adversecamber, Jul 27, 2008

    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).
     
    share
    + Quote Reply
  6. oldtime, Jul 27, 2008

    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
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page