Blank rows can be a not so small nuisance in data collection applications. In addition to making data management harder, an unorganized data set filled with blanks can mess with your calculations. Furthermore, Excel uses blanks as limits of ranges when you add a table, sort, or filter data. There are various ways to do this in Excel, but one of the easiest ways to get rid of empty cells is using this method. In this article, we’re going to show you how to remove blank rows in Excel using filters.
Steps to remove blank rows in Excel
- Select all your data containing the blank rows.
- Activate the filters by pressing the Ctrl + Shift + L combination or going to DATA > Filter in the ribbon.
- Leave only the (Blanks) item checked and click OK to apply the filter.
- Since all blank rows are excluded, you can now easily select all by pressing the Ctrl + – combination or clicking the Delete Row option in the right-click menu to delete the unwanted rows.
- Clear the filter to display the remaining cells with data.
For more information about organizing your data, like ordering cells in a custom order, please see the related article.