Removing Blank Rows

S

scasawyer

Hello All

Having trouble finding a way to remove blank row on a spread sheet this is
what i need
i hav a sheet like this

546 6574 7484

748589 4845845 9494

484894 93483 3483894

4384 34873

Well i need to find a way to remove the empty rows, seem like it should be
easy but can't seem to get it


Thanks for any help

Scott
 
D

Don Guillett

One simple way is to sort and delete wholesale or use a macro (search
archives for this OFTEN asked question)
 
P

puppet_sock

scasawyer said:
Hello All

Having trouble finding a way to remove blank row on a spread sheet this is
what i need
i hav a sheet like this

546 6574 7484

748589 4845845 9494

484894 93483 3483894

4384 34873

Well i need to find a way to remove the empty rows, seem like it should be
easy but can't seem to get it
Click to expand...

Can think of a few ways:

- If you don't care about order, you could do a sort. This will push
all the blank rows into a block. Sadly, it will also sort the rows
that are non-blank.
- You could add columns to facilitate the sort. Something like
a count in the first column. Then something like
if(c1 = "","", a1) in the b column. Then sort on the b column.
This would preserve order of the non-blank rows.
After, just delete the unwanted columns.
- You could write a macro that checks if the first cell is empty, and
if it is deletes the row. Otherwise it goes to the next row. Then
just run this macro a bunch of times. Either find out how long the
sheet is, or put it on a key stroke and just hold down that key.
Socks
 
Top