View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MANU MANU is offline
external usenet poster
 
Posts: 10
Default deleting the blank rows from the sheet

Hi

Thanx for replying me in time for my earlier question.

I have a data of 15000 rows. My problem is there are spaces of a row or two
between each records. I could have sort it to remove the blank rows in
between. But do not want to change the order of the records. pls suggest
the right way to remove blank rows from the records in short period of time.

thanx in advance.
Manu