How to select all empty lines?

S

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

Regards,
Sirritys
 
S

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

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
 
R

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

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
 
Top