delete records in one column from added records below that column

Occasional Visitor

Excel 2016. Yes, newbie. I have a spreadsheet with six columns of records. Company, name, title, phone, email and type. 2000 total records. I want to remove my verifed BAD emails from the email column and then extend to the entire row. So, the deleted email cell deletes the entire record row. Can I do without a macro formula? Xie xie xie for any help.

1 Reply

Hi Emily,


To delete the entire row, highlight the entire row and press delete, as shown in the below screenshot:


Delete entire row.png


Another way: 

 - Select any single cell, right-click, and select Delete.

 - From the delete dialog box, select the entire row option, then hit OK.


You can filter that bad emails then highlight them and delete them at once.