Hi Heather

Work on a COPY of your data, just in case!!!

You could use an extra column alongside your data. Enter 1, 2 in the first 2
rows of this columnselect the 2 cellsgrab the fill handle at bottom right
of cell containing the number 2fill down as far as you data extends.

Now, Sort the entire block (including your new column) by any column that
must have data to be retained.
All rows which have a blank in this position, will be sorted to the bottom
of the list.
Delete the block of rows at the bottom of the list, then sort again by the
new column to get the data back into it's original order.
Delete the added new column

--
Regards
Roger Govier



"Heather" wrote in message
...
Hi, I need to find a way to delete wholly blank rows from a spreadsheet
that
also includes blank cells.
I tried F5special...radio button BlanksOK ctrl+- delete rows , but
that
also deletes rows that have data in them along with a blank cell!

Is there an equally neat way of deleting rows that have no data in them at
all, but leaving partial rows?