Select all of column B.
Press F5, Special, Blanks, OK
Press Ctrl-Minus and Entire Row.

--
Jim
"kippers" wrote in message
...
| Hi,
|
| I have a spreadsheet with nearly 20,000 rows and around 20 columns- every
so
| often a blank cell appears (it is always in the 2nd column) - I want to
| delete the entire row on which this blank cell is placed. This happens
| roughly every 10-15 rows so it would be far too time consuming to go
through
| 20k rows manually- can anyone give me a quick and easy way of deleting
these
| rows?
|
| Any help gratefully appreciated!
|
| cheers
|