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

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?

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

Hi PP,

If they are full blank rows:

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

Judith
--
Hope this helps


"pp" wrote:

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?