I need to remove empty lines from a very large spreadsheet
A Ashish Mathur Apr 21, 2005 #2 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
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
A Andri Apr 21, 2005 #3 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
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
