remove blank lines from an entire spreadsheet
 

I need to remove empty lines from a very large spreadsheet

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

hope it will help, got from this group also...
put as macro:
Sub Macro1()
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub

"mdeanda" wrote:

I need to remove empty lines from a very large spreadsheet