Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Moving non-hidden rows (Excel XP)

    I have a list that I want to divide into two lists, based on a text criterion in one of the fields. I have no problems setting up an autofilter to just show the rows that satisfy my citerion. Now I want to cut and paste those rows to a new list, leaving behind the rows that don't satify the criterion. However, when I do this the only practical way in my case (dragging over the row headings, i.e., not selecting them individually), the *whole* list gets moved. Experimenting further, I see that this behaviour is more general, and applies whenever you have hidden rows or columns. Is there any easy way I can select *only* the visible rows so that I can do my cut and paste to form my new list?

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Moving non-hidden rows (Excel XP)

    I think what you're after is "edit/go to/special/visible cells only." However, note that cut will not work here as you'll end up with multiple selections, so you'll have to copy, paste and then delete the originals. Also, you'll have to preserve the header row.

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Moving non-hidden rows (Excel XP)

    Sure. Select the entire filtered table, then select from the standard Menu, Edit, GoTo, Special, Visible Cells Only, then perform your Cut&Paste.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Lounger
    Join Date
    Jan 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Moving non-hidden rows (Excel XP)

    Thanks, that *almost* did it. Excel won't allow you to do a cut on the multiple selection. However, I could do a copy and then a Delete Row, and that did it for me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •