Delete multiple rows where a blank cell is located
 

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

Delete multiple rows where a blank cell is located
 

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
|

Delete multiple rows where a blank cell is located
 

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?