Empty Rows

  • Thread starter Thread starter Daniel
  • Start date Start date
You can use 'Go To'>'special'>'blanks' if you are looking for empty cells in
a column.
When you range is more than one-column and you are looking for rows with all
cells blank
you can add a new column, concatenate all cells from your range, paste the
formula into all
rows and then perform 'Go To'>'special'>'blanks' on that column.
Alternatively you can use
autofilter if your new column is adjacent to your range.
regards
 
Try this on a back-up copy:

Select any one representative column
(Assume the blank cells in this rep. column
run right across the data set, ie empty rows)

Press F5 > Special > Check "Blanks" > OK
(All the blank cells in between data will be selected)

Click Edit > Delete .. > Entire row > OK
 
But if you concatenate the cells in that row into that helper cell, then that
cell won't be blank. It'll contain the formula that concatenates the other
cells.

Applying Data|filter|autofilter and filtering on just the blank cells and
deleting those visible rows would work nicely though.

Or you could use this formula, too:
=counta(a1:x1)
Then filter on that column to show the 0's and delete those visible rows.
 
Daniel said:
How can I delete (easy) the empty rows from a worksheet?

Thanks
Click to expand...
Select the entire row by clicking on the row number on the left & press the
Delete key.
Mike.
 
Back
Top