Forum Discussion
delete records in one column from added records below that column
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. jim@hob-products.com
1 Reply
Hi Emily,
To delete the entire row, highlight the entire row and press delete, as shown in the below screenshot:
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.
