Excel – delete row from Excel where column cell is empty

microsoft excel

I have a list of hundreds of users in an Excel spreadsheet. I want to remove all of the users that don't have their email address in there spreadsheet entry. there's a column called 'email', so how would I remove all the rows with a blank 'email', without having to go through every entry and delete each one manually.

Bear in mind I'm a complete newbie on Excel; I'm not sure how to run code. Some pointers would be very helpful!

Best Answer

Select the 'email' column and go Data > Filter > AutoFilter to add a filter to that column. That will add a dropdown menu to the column (a little triangle). From this filter you can choose to show only the empty rows. Then you can select them all and delete by right-clicking on the row label and selecting 'Delete Rows'.

Related Question