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.