FG

delete row from Excel where column cell is empty

Fresh3 days ago
Mar 15, 202611355 views
Confidence Score0%
0%

Problem

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…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: delete row from Excel where column cell is empty

Low Risk

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 an…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment