View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JudithJubilee JudithJubilee is offline
external usenet poster
 
Posts: 52
Default 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?