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

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

--
Jim
"kippers" <(E-Mail Removed)> wrote in message
newsD0E22D8-2FB8-48F1-933C-(E-Mail Removed)...
| 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
|

kippers wrote:
> 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
>
Could you auto filter the sheet then column two to show blanks and just
delete all the visible data in the other columns?