Skip to content

Instantly Delete All Empty Rows

This post is going to be short and sweet!

Have you ever faced the problem of having a bunch of data in an Excel spreadsheet with a whole lot of missing rows? Something like the picture below for instance?

It can be such a pain to go row by row just to get rid of all those empty cells.

Well here is some excellent news! You don’t have to go through that painful process ever again.

Here is a simple trick you can use to instantly delete all of those empty rows in Microsoft Excel.

Step No. 1 – Use CTRL+G

Ctrl + G

Hitting Ctrl+G (meaning hit the Ctrl key and “G” at the same time) opens up the “Go To” dialog box in Excel.

Usually this is used to help navigate you to a specific place in your workbook, but it has other uses too.

Step No. 2 – Hit the Special Button

Next, you will want to click on the “Special…” button located at the bottom left corner of the dialog box.

This will open up the “Go To Special” dialog box that you see below.

Here, select the “Blanks” option and then click “Ok.”

This will highlight all of those pesky empty rows that we are trying to get rid of.

Step No. 3 – Right Click and Delete

Now that we have highlighted all of the cells we wish to get rid of, simply right click on any of them and click “Delete…”

Once you’ve done that, you want to be absolutely sure that you select the “Shift Cells Up” option. If you select the “Shift Cells Left” option, then we will still have the same problem that we did before.

Once you do that…BOOM…all of those pesky empty rows are gone and you’ve got your data all cleaned up. It’s really that easy!

This Post Has One Comment

  1. I never knew! I’m going to use this all the time at work now! This is so much easier than what I was doing before!

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