delete rows where a cell is blank in specific column

G

GottaRun

Hi All,

How do I filter the rows where in column B a cell is not a blank?
Then presumably I can delete only those rows resulting in a sheet wher
every cell in column B is a blank.

Thanks
 
G

Guest

Hi

Go to Data/Filter/Autofilter. Using the little arrows on the top row, select
'Non-blank' in column B.

Andy.
 
G

Gord Dibben

Select column B

F5>Special>Blanks>OK

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP
 
Top