Delete empty rows

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I have 2 columns of data with 15000 rows. Some of the
rows in the 2 columns are completely empty and I need to
delete them. e.g.
1111 2321
3123 5556
3124 3344

3244 5566
3332 3344


4645 3353
______________
convert to:
1111 2321
3123 5556
3124 3344
3244 5566
3332 3344
4645 3353

If anyone can help I would really appreciate it.

don
 
Easy way: Select the range, press F5,
click special, select blanks, press ctrl -
select entire row, click OK.

Btw, do this on a copy so you can make sure
the whole row was empty
 
Don

Select the 2 columns and Edit>Go To>Special>Blanks>OK

Now with blanks selected Edit>Delete>Entire Row.

If you have other columns with data and you don't want to delete entire rows
you can Edit>Delete>Shift Cells Up.

Gord Dibben Excel MVP
 
Back
Top