Excel: Delete row if cell in certain column is blank

microsoft excel

I want to delete all of the rows that don't contain a value in column C. How would I go about doing this?

Best Answer

You can do this very quickly if the cells are truly blank using SpecialCells

Manual

  • Select Column C
  • Press F5, then Special
  • Check Blanks, then OK (see this step in the pic at bottom)
  • Delete the rows that are now selected (e.g. right click in selection > Delete cells... > Entire row or via the ribbon (see second screenshot))

VBA

Sub QuickCull()
    On Error Resume Next
    Columns("C").SpecialCells(xlBlanks).EntireRow.Delete
End Sub

Screenshot showing the Go To Special -> Blanks menu Screenshot showing how to use the ribbon to delete entire rows in selection

Related Question