Skip to content

How to Delete Blank Rows in Excel

How do you delete blank rows in Excel? This article will show you how to do it!

Step 1 – Use CTRL + G

The first thing you want to do is to use the keyboard shortcut CTRL+G to open the Go To dialog box.

Step 2 – Click on Special & Select Blanks

From here, click on Special, and this will open the Go To Special dialog box.

Select the Blanks option, and click on Ok.

Step 3 – Right-Click and Delete

For the final step, right-click on any highlighted cells, and select Delete.

Select the option, Shift cells up, and click on Ok.

This deletes all the empty rows in Excel, leaving you with clean and effective data.

See It in Action

Check out the video below to see this in action.


If you have other questions like this that you would like answered in the Spreadsheet Life blog, leave a comment below and let me know.

I’d love to write an article to answer any questions you may have!

This Post Has One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top