How to select all empty lines?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sirritys - 30 Jun 2006 10:23 GMT

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 :o)

Regards,
Sirritys

Reply to this Message

starguy - 30 Jun 2006 10:49 GMT

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

Sirritys Wrote:

> 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
[quoted text clipped - 4 lines]
> Regards,
> Sirritys

Signature

starguy

Reply to this Message

MartinW - 30 Jun 2006 11:06 GMT

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

Reply to this Message

Roger Govier - 30 Jun 2006 11:15 GMT

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.

Signature

Regards

Roger Govier

>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
[quoted text clipped - 4 lines]
> Regards,
> Sirritys

Reply to this Message

Buffyslay - 30 Jun 2006 11:19 GMT

"Sirritys" <aki.koikkalainen@hotmail.com> wrote in message

> news:1151659396.903853.109780@x69g2000cwx.googlegroups.com...
> >I have annoying sheet that has empty lines here and there and I need to
[quoted text clipped - 5 lines]
> > Regards,
> > Sirritys

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

Reply to this Message

CLR - 30 Jun 2006 14:46 GMT

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

> 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
[quoted text clipped - 4 lines]
> Regards,
> Sirritys

Reply to this Message

Sirritys - 03 Jul 2006 06:03 GMT

Thank you all.

Now I have plenty of solutions to choose from =)

-Sirritys

Reply to this Message