From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,000 courses taught by industry experts.

Delete unneeded rows

Delete unneeded rows - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Delete unneeded rows

“

- [Instructor] All right, let's see if we can make this quick. We have all of these survey results. Let's look at the data. We got Monday, Tuesday. We'll scroll down. There's a Wednesday and Thursday data. Right, we've got the survey codes, and here is what's needed. If a survey does not have a status, we want to delete the entire row, like 6J56 has no status. We want it all gone, but we've got to be careful in whatever strategy we use because we still do want to keep the day headers. So don't accidentally delete the Monday, Tuesday, et cetera, all right? Now, it's time to pause the video and get rid of the rows that we don't need. (upbeat jazz music) (ethereal music) Here we go! We do want to keep these. All right, so here is what I'm going to do. Right-click, Insert, Shift cells down. Look at that, so now, we can keep the headers. Next, to get rid of the ones that don't have a status. Here we go. I'm…

Contents