Deleting blank cells in a column

[KatyLady]

Hi,

I have a column that has about 1000 empty cells, every cell that i
blank I would like to delete. How can I do this without going to eac
individual row? Thanks!

K

 

[KatyLady]

Thanks so much! It worked, I could only do about 500 rows at a time or
it would freeze up on me, but that'll work for me.

 

[gonowhere]

Another thing you could try is to select the column and sort it
("Data">"Sort") and depending on how you sort it your blank cells will
either be at the bottom or top of the sheet.

 

[Ragdyer]

Select the column, then
<F5>,
Click <Special>
Click <Blanks>
Right click in selection,
And choose what you wish to delete, cells or entire rows.

 

[KatyLady]

Okay, that works too, and deleting doesn't seem to freeze it up.
Thanks!

 

[Guest]

This is a very useful tool, but I have deleted rows I didn't mean to before.
Always chaeck to make sure that just cause one cell is blank, tyhat you want
to delete anything else in that row.