How to select all empty lines?

[Sirritys]

I have annoying sheet that has empty lines here and there and I need to
get rid of them. So is there a way to choose every empty line
automatically.

(I'm not looking forward doing this manually to 10K lines )

Regards,
Sirritys

 

[starguy]

for choosing empty cells Edit > Go To > click on Special > select
Blanks
all empty cells will be selected with the range of your data.

 

[MartinW]

Hi Sirritys,

Try autofilter and filter by (Blanks), you may have to keep filtering
by different columns until you get all the empty rows.
Then highlight the rows and edit>delete rows.

HTH
Martin

 

[Roger Govier]

Hi

You could mark the whole range of data and Sort on relevant column.
All empty rows would then be moved to the end of the list.
Do this on a COPY of your data first just in case the sort produces
undesirable side effects.

 

[Buffyslay]

or you could a 'data | filter' and filter down that way....
then you could see that all the lines being removed are actually empty

 

[Guest]

ASAP Utilities, a free Add-in available at www.asap-utilities.com has a
feature that will delete all rows with a blank in a specific column........

Vaya con Dios,
Chuck, CABGx3

 

[Sirritys]

Thank you all.

Now I have plenty of solutions to choose from =)

-Sirritys