Empty Rows

[Daniel]

How can I delete (easy) the empty rows from a worksheet?

Thanks

 

[Max]

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

 

[Dave Peterson]

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.

 

[Mike Cawood]

How can I delete (easy) the empty rows from a worksheet?

Thanks

Select the entire row by clicking on the row number on the left & press the
Delete key.
Mike.