Share via

delete filtered rows

Anonymous
2013-10-07T21:47:53+00:00

This may seem a rather basic question. However, I am not sure I am carrying out the procedure in the best way possible.

What is the best way to delete rows which have been filtered? At the moment, I just filter the data I want to remove, select those rows and then delete. However, this is a bit cumbersome if you have a lot of rows to delete what with all that scrolling down to the bottom etc.

I would have thought there would have been an easier/more efficient way to do this?

Also, I am never really sure that the underlying data is not going to be accidentally deleted too.

Any advice is much appreciated.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-10-07T22:49:16+00:00

    Once List is filtered. Select 1st Filter line. Then Just press Shift and Down Arrow key. It will select till the last filtered row. Now you can delete the rows with right mouse click and delete rows.

    Always click 'Reapply' button in Sort & Filter Tab before deleting any row so that you are sure that you are not deleting hidden data accidentally.

    10+ people found this answer helpful.
    0 comments
  2. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2013-10-08T01:26:26+00:00

    Hi,

    The key to ensuring that on a filtered data set, only filtered rows get deleted, is filtering correctly in the first place.  Before filtering, ensure that you manually select the entire dataset with the first row as the hidden row and then click on the Filter icon.  Now when you delete/copy the filtered data, only the visible cells will get deleted/copied.

    5 people found this answer helpful.
    0 comments