Delete multiple rows where a blank cell is located

  • Thread starter Thread starter kippers
  • Start date Start date
K

kippers

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
| 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 said:
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
Click to expand...
Could you auto filter the sheet then column two to show blanks and just
delete all the visible data in the other columns?
 
Back
Top