Hi,

Select the sheet area containing the text and blank cells. Do the following

1. Ctrl+G
2. Go to Special
3. Select blanks
4. Click OK

It will highlight all the blank rows in Blue. Now do the following

1. Alt E+D+R (To deletye the rows)

Regards,

Ashish Mathur






"mdeanda" wrote:

> I need to remove empty lines from a very large spreadsheet