+ Reply to Thread
Results 1 to 2 of 2

Delete only Filtered Rows not hidden rows in excel 2001

  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    3

    Delete only Filtered Rows not hidden rows in excel 2001

    Hi,
    For deleting rows which you have filtered (eg : rows having name ROYA in column Name) not the other rows.
    I tried folowing way it worked:

    1. Keep the cursor on header cell eg, I wanted to filter by Name so I kept my cursor in Name Header.
    2. Click on Data>Filter
    3.Select Rows Number at Left most
    4. Right Click> Delete Rows

    Note: If only Delete option is displayed then it will delete hidden rows also, Try and follow steps again the option should be 'Delete Rows'

    Please let me know if it worked
    Gud Luck

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Delete only Filtered Rows not hidden rows in excel 2001

    After Step 3 Press Alt+; (Semi Colon) which will select Visible Cells only and perform the Step 4 action


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 06-07-2018, 04:16 PM
  2. Keep hidden rows hidden, in a protected, filtered worksheet
    By djp630 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2014, 10:22 PM
  3. Replies: 4
    Last Post: 06-11-2010, 03:29 PM
  4. [SOLVED] hidden/filtered rows
    By Mike in forum Excel General
    Replies: 0
    Last Post: 04-19-2006, 05:35 PM
  5. Excel - How do I delete filtered out rows?
    By rook in forum Excel General
    Replies: 2
    Last Post: 11-30-2005, 06:50 PM

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