delete rows where a cell is blank in specific column

  • Thread starter Thread starter GottaRun
  • Start date Start date
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
 
Hi

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

Andy.
 
Select column B

F5>Special>Blanks>OK

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP
 
Go to Data/Filter/Autofilter.
Using the little arrows on the top row, select
'Non-blank' in column B.
Click to expand...

... adding on a little to Andy's suggestion above <g> ...

Select the filtered "blue" row headers,
right-click on these > Delete Row
Remove autofilter

Note: Choose "(blanks)" from the droplist
if you want to delete **blank** rows
(From your subject line, I believe this is what you want to do)

GottaRun:
You've got a response in your (ugh!) multi-post
in .worksheet.functions as well
(Pl refrain from multi-posting)

---
 
Back
Top