One way - hide rows with data and then delete visible rows.
This is quickest if you use the keyboard shortcuts

1. Select the whole datasheet (Ctrl+A twice) then press...

Shift+Tab (selects last data cell)
Ctrl + \ (Edit Goto Special Row Differences)
Ctrl + 9 (Format Row Hide)

2. Select whole datasheet again then:

Alt+; (Edit Goto Special Visible Cells)
Ctrl - (Edit Delete)

Now select the datasheet and unhide the rows.

"Heather" wrote:

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?