Search code examples
excelvbaxlsx

Excel delete entire row where is first cell empty


How do I delete an entire row, when the first cell is empty?

enter image description here


Solution

  • You can sort on column A that will put all the blank lines together. Then you can select all the blank lines in one go and delete them

    OR

    You select your table, and click filter, then filter on the column and show only blanks then select those rows individually (not drag select) and delete them. See image here