deleting rows with empty cells

[nn992]

Hi everyone,

I am trying to delete all rows with empty cells in excel. I have 250k and more rows, and I want to delete entire row if a cell in field H is empty.

I tried trick with Find-Go to special-Blanks, but it selects me only the last cell of collumn H (and there are many other empty cells)

to make it clear, entire collumn H is formula, and I want to delete the rows where the formula returns empty field

 

[jkpieterse]

Filter the table for the value of column H you want deleted, then use goto special visible cells only and delete.