how to delet the blank rows in whole sheet at a time

  • Thread starter Thread starter pp
  • Start date Start date
P

pp

I have a similar problem with an import into Excel2003. from tyelly one blank
row adjusent with data
just I wish to delete only rows where both are blank.
Can i do at a time? Can someone help?
 
Hi PP,

If they are full blank rows:

Highlight Column A, Choose Ctrl + G + Special. Choose Blanks + OK.
Choose edit + Delete Rows.

Judith
 
Back
Top