Blank rows are a common problem especially when it is gathered by importing or inexperienced user entry. They can be hard to get rid of, and Excel uses blanks as limits of ranges when you use features like adding a table, sorting or filtering. In this article, we're going to show you how to use the Go To feature to make Excel delete blank rows.
How to make Excel delete blank rows
- Select the data containing blank rows.
- Open the Go To Special dialog from HOME > Find & Select > Go To Special in the ribbon.
- Select the Blanks option.
- All that is left should be blank rows, select them all and then press the Ctrl + - combination.
- Click the OK button to apply your selection.
You might want to be extra careful when removing blank rows using the Go To feature, because it selects individual blank cells in rows that have values. Removing them will cause data loss, even though you can revert your actions with Undo.