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