Forum Discussion
Formula required
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
- 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/ 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.
