Excel how to delete filtered rows

Excel how to delete filtered rows

Data management requires the use of a spreadsheet, and it is good for your Excel rows to be unique. In some cases, you may encounter several identical rows containing different data and information. To have a decent working environment on excel, you should know how to filter your worksheet and delete some of the problematic rows. You can carry out this procedure in a few simple steps. I am going to put you through on how to delete filtered rows from your excel spreadsheet.

All you have to so is to work in a reverse pattern, and it is straightforward.

Firstly, open your Excel worksheets and check the columns and filter.

Uncheck all the rows that you want to keep. You will be left with the ones that are Left will be unwanted.

Delete the unwanted rows and save the remaining file with a new name. You can quicken the process by making use of shortcuts on your keyboard.

 

Here are the shortcuts:

>> Filter

>> Select the cell in the next row down. (Ensure that there is data in the entire column)

>> Press CTRL + SHIFT + Down arrow

>> Ctrl + (minus sign)

>> R (for row.)

>> Enter.

The above shortcuts do not work perfectly in all versions of Excel. Some Excel versions may display an empty screen just before you delete the data, hence leaving you with nothing after the deletion.

However, some users can decide to exclude the parts that are filtered by copying the filtered parts and pasting the same in a new spreadsheet. This method has its downside because you will be working in a different window/spreadsheet, which may not augur well for you.

Another issue with this method is that it fails to maintain the sizes of the rows and columns.

There is a way out of this, though, for only the column width. You can use a special keyboard shortcut to paste in a new spreadsheet, and it will maintain the widths of the column. The shortcut to use is the ”W” button on the keyboard.

The best of it all is to use colors. You can use colors to mark the rows and columns that you want to delete, and then you do the filtering between colors.

Here is the summary of the entire procedure:

>> Do the filtering process and pick out the items you want to keep.

>> Choose a column and fill with your desired coloration.

>> Remove the Filter

>> Carry out another filtering. This time, you should use color to filter in the column. Select ”No Fill.”

>> Delete the marked rows & clear all the filters.

These summarized steps are cool. It will leave you with your desired rows after the deletion of the filtered rows. More so, the data will remain on the same worksheet, and the column/row sizes will be maintained.