Deleting blank cells in a column

K

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
 
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. :)
 
G

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.
 
R

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.
 
B

bj

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.
 
Top