Deleting Blank Rows In Your Data In #Excel

Here’s how to find and delete blank rows from your data range without the use of a mouse:

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Here I have a data range that has several blank rows. I want to delete all the blank rows so I have a nice, consolidated data range:

blank1

We are going to do this without using a mouse. Here are the steps that we will follow:

blank2

Let’s take it step by step:

Highlight the area using Shift + cursor movement keys:

blank3

F5 – this will bring up the Go To dialog box:

blank4

Alt S – this will select Special:

blank5

Alt K – this will select Blanks:

blank6

OK – this will select all the blank rows in the highlighted range:

blank7

Alt H D R – this will select Delete Rows from the Cells group on the Home tab:

blank8

And now we have a nice, clean data range:

blank9

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , ,

No comments yet.

Leave a Reply