Home

delete records in one column from added records below that column

%3CLINGO-SUB%20id%3D%22lingo-sub-124271%22%20slang%3D%22en-US%22%3Edelete%20records%20in%20one%20column%20from%20added%20records%20below%20that%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-124271%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%202016.%20Yes%2C%20newbie.%20I%20have%20a%20spreadsheet%20with%26nbsp%3Bsix%20columns%20of%20records.%20Company%2C%20name%2C%20title%2C%20phone%2C%20email%20and%20type.%202000%20total%20records.%20I%20want%20to%20remove%20my%20verifed%20BAD%20emails%20from%20the%20email%20column%20and%20then%20extend%20to%20the%20entire%20row.%20So%2C%20the%20deleted%20email%26nbsp%3Bcell%20deletes%20the%20entire%20record%20row.%20Can%20I%20do%20without%20a%20macro%20formula%3F%20Xie%20xie%20xie%20for%20any%20help.%20jim%40hob-products.com%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-124271%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eremove%20cells%20and%20extend%20to%20entire%20row%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-124280%22%20slang%3D%22en-US%22%3ERe%3A%20delete%20records%20in%20one%20column%20from%20added%20records%20below%20that%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-124280%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Emily%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20delete%20the%20entire%20row%2C%20highlight%20the%20entire%20row%20and%20press%20delete%2C%20as%20shown%20in%20the%20below%20screenshot%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F23552iFE27D925ACB1E8E7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Delete%20entire%20row.png%22%20title%3D%22Delete%20entire%20row.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20way%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Select%20any%20single%20cell%2C%20right-click%2C%20and%20select%20Delete.%3C%2FP%3E%3CP%3E%26nbsp%3B-%20From%20the%20delete%20dialog%20box%2C%20select%20the%20entire%20row%20option%2C%20then%20hit%20OK.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20filter%20that%20bad%20emails%20then%20highlight%20them%20and%20delete%20them%20at%20once.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Emily McGone
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. 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:

 

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.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
207 Replies