+ Reply to Thread
Results 1 to 5 of 5

How to delete multiple rows without deleting the hidden rows when filtered?

  1. 06-08-2010, 07:35 PM #1
    geng
    geng is offline
    Registered User
    Join Date
    05-31-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    88

    How to delete multiple rows without deleting the hidden rows when filtered?

    I have a filtered data and I need to delete only the visible rows.

    How do you do that without deleting the hidden rows?

    Thanks!
    Last edited by geng; 06-08-2010 at 09:33 PM.
    Reply With QuoteRegister To Reply
  2. 06-08-2010, 08:49 PM #2
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: How to delete multiple rows without deleting the hidden rows when filtered?

    Hi geng,

    The following will delete all visible rows from Column A (change to suit):

    Please Login or Register  to view this content.
    HTH

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
    Reply With QuoteRegister To Reply
  3. 06-08-2010, 09:32 PM #3
    geng
    geng is offline
    Registered User
    Join Date
    05-31-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: How to delete multiple rows without deleting the hidden rows when filtered?

    Thanks Trevor!
    Reply With QuoteRegister To Reply
  4. 06-08-2010, 10:17 PM #4
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: How to delete multiple rows without deleting the hidden rows when filtered?

    You're welcome
    Reply With QuoteRegister To Reply
  5. 06-11-2010, 03:29 PM #5
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: How to delete multiple rows without deleting the hidden rows when filtered?

    Or, after selecting your range, F5 (Goto) > Special>Visible cells only. Then delete rows.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1