From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Close holes in a list

Close holes in a list - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Close holes in a list

“

- [Instructor] Today we need to close the gaps in this list. These names go all the way down to row 61 down to Foster Vasquez. We need to clear all of those empty cells. Do not sort this list. Do not delete the empty cells one at a time. All right? Pause the video, close these holes, come back, we'll go through it together. Right, let's do it. I'm going to highlight and then in Home, Find & Select, Go To Special, Blanks, OK. Our blank cells are highlighted, right-click, delete. Shift cells up, OK. Hot dog, check that out. One solid list.

Contents