From the course: Excel: Productivity Tips

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Removing blank rows

Removing blank rows - Microsoft Excel Tutorial

From the course: Excel: Productivity Tips

Start my 1-month free trial

Removing blank rows

“

- [Instructor] All right, for this tip I want to show you guys how to remove all of the blank rows in a worksheet in one go. Now this sounds like something that should be pretty easy to do, but it can actually be quite challenging without using the right tools. So in this case, we're going to use the Go To special options, which we covered in the last demo and select blanks to get rid of all of those pesky blank rows. So Control + G is going to launch your basic Go To options. And then again, that special button is going to allow us to highlight or isolate specific types of cells within the sheet. So in this case, we're going to use the blanks option. And that's going to select all of those blank rows within the active range. And from here, the only thing left to do is actually delete those blank rows. You can do it in a few different ways. First, you can navigate to the Home tab, press Delete, and then delete…

Contents