Deleting Blank Rows.

  • Thread starter Thread starter GEM
  • Start date Start date
G

GEM

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???
 
try this

Select a column then F5>Special>Blanks>OK
Edit>Delete>Entire 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
 
Back
Top