Formula required

%3CLINGO-SUB%20id%3D%22lingo-sub-1594135%22%20slang%3D%22en-US%22%3EFormula%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1594135%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20anyone%20help%20me%20with%20a%20formula%20please%3F%3C%2FP%3E%3CP%3EI%20need%20to%20find%20all%20blank%20cells%20within%20a%20column%20and%20delete%20all%20the%20rows%20containing%20the%20blank%20cells.%3C%2FP%3E%3CP%3EThankyou%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1594135%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1594213%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1594213%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F489780%22%20target%3D%22_blank%22%3E%40Kelly290%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20don't%20do%20that%20with%20a%20formula.%3C%2FP%3E%0A%3CP%3ESelect%20the%20column%20by%20clicking%20on%20its%20column%20header.%3C%2FP%3E%0A%3CP%3EPress%20F5%20or%20Ctrl%2BG%20to%20activate%20the%20Go%20To%20dialog.%3C%2FP%3E%0A%3CP%3EClick%20Special...%3C%2FP%3E%0A%3CP%3ESelect%20Blanks%2C%20then%20click%20OK.%3C%2FP%3E%0A%3CP%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20in%20the%20Cells%20group%2C%20click%20Delete%20%26gt%3B%20Delete%20Sheet%20Rows.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1594409%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1594409%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20check%20out%20how%20to%20identity%20and%20delete%20all%20blank%20rows%20in%20Excel%20and%20Power%20Query%20in%20the%20link%20below%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.exceljetconsult.com.ng%2Fhome%2Fblog%2Fdelete-blank-rows-in-power-bi-and-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.exceljetconsult.com.ng%2Fhome%2Fblog%2Fdelete-blank-rows-in-power-bi-and-excel%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Can anyone help me with a formula please?

I need to find all blank cells within a column and delete all the rows containing the blank cells.

Thankyou

2 Replies

@Kelly290 

You don't do that with a formula.

Select the column by clicking on its column header.

Press F5 or Ctrl+G to activate the Go To dialog.

Click Special...

Select Blanks, then click OK.

On the Home tab of the ribbon, in the Cells group, click Delete > Delete Sheet Rows.

Hello,

You can check out how to identity and delete all blank rows in Excel and Power Query in the link below

https://www.exceljetconsult.com.ng/home/blog/delete-blank-rows-in-power-bi-and-excel/