Deleting Blank Rows.
 

I have a spreadsheet which has one row with data and one row blank, it's
about 1000 rows down, is there any way I can delete the blank rows. If I
apply autofilter it won't catch the other rows after the first one, is there
any way to delete all the blank rows???

Deleting Blank Rows.
 

f5gotospecial blanksthen delete

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"GEM" wrote in message
...
I have a spreadsheet which has one row with data and one row blank, it's
about 1000 rows down, is there any way I can delete the blank rows. If I
apply autofilter it won't catch the other rows after the first one, is
there
any way to delete all the blank rows???

Deleting Blank Rows.
 

try this

Select a column then F5SpecialBlanksOK
EditDeleteEntire Row
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"GEM" wrote:

I have a spreadsheet which has one row with data and one row blank, it's
about 1000 rows down, is there any way I can delete the blank rows. If I
apply autofilter it won't catch the other rows after the first one, is there
any way to delete all the blank rows???

Deleting Blank Rows.
 

Great thanks!!!!

"Don Guillett" wrote:

f5gotospecial blanksthen delete

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"GEM" wrote in message
...
I have a spreadsheet which has one row with data and one row blank, it's
about 1000 rows down, is there any way I can delete the blank rows. If I
apply autofilter it won't catch the other rows after the first one, is
there
any way to delete all the blank rows???