+ Reply to Thread
Results 1 to 4 of 4

How do you delete filtered rows in an autofiltered list. The row.

  1. #1
    The Dunce
    Guest

    How do you delete filtered rows in an autofiltered list. The row.

    When I auto filter a spreadsheet, I can't figure out how to delete or
    eliminate from the sheet the filtered-out rows. So when I refilter the sheet
    with new items to get rid of, the old filtered items come back. I've tried
    copying the range to another file, but I always get all the old data in the
    new file.

  2. #2
    Gary Rowe
    Guest

    RE: How do you delete filtered rows in an autofiltered list. The row.

    Select the rows you want to delete and click edit, delete.

    "The Dunce" wrote:

    > When I auto filter a spreadsheet, I can't figure out how to delete or
    > eliminate from the sheet the filtered-out rows. So when I refilter the sheet
    > with new items to get rid of, the old filtered items come back. I've tried
    > copying the range to another file, but I always get all the old data in the
    > new file.


  3. #3
    RagDyeR
    Guest

    Re: How do you delete filtered rows in an autofiltered list. The row.

    Select the filtered data, then:
    <F5> <Special>,
    Click on "Visible Cells Only", then <OK>,

    Right click in the selection and choose "Copy".

    Then simply navigate to an area of the sheet where there are *no* hidden
    rows from the filtering, and "Paste".

    --

    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================


    "The Dunce" <The Dunce@discussions.microsoft.com> wrote in message
    news:3C3381F9-CABC-4975-A5BF-E21CDD200DE6@microsoft.com...
    When I auto filter a spreadsheet, I can't figure out how to delete or
    eliminate from the sheet the filtered-out rows. So when I refilter the
    sheet
    with new items to get rid of, the old filtered items come back. I've tried
    copying the range to another file, but I always get all the old data in the
    new file.



  4. #4
    The Dunce
    Guest

    RE: How do you delete filtered rows in an autofiltered list. The

    Thanks Gary, but once you've filtered a spreadsheet, you can't see the rows
    you want to delete.

    At any rate, I think I've found the answer. An early post to this group
    asked a similar question. The answer was to hit F5. That gives you the
    select region choice. Wish I'd known this yesterday. I spent at least 5
    hours trying to figure it out.

    "Gary Rowe" wrote:

    > Select the rows you want to delete and click edit, delete.
    >
    > "The Dunce" wrote:
    >
    > > When I auto filter a spreadsheet, I can't figure out how to delete or
    > > eliminate from the sheet the filtered-out rows. So when I refilter the sheet
    > > with new items to get rid of, the old filtered items come back. I've tried
    > > copying the range to another file, but I always get all the old data in the
    > > new file.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1