Removing Blank Rows

  • Thread starter Thread starter scasawyer
  • Start date Start date
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
 
One simple way is to sort and delete wholesale or use a macro (search
archives for this OFTEN asked question)
 
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
 
Back
Top