Home |
Search |
Today's Posts |
#1
|
|||
|
|||
remove blank lines from an entire spreadsheet
I need to remove empty lines from a very large spreadsheet
|
#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 "mdeanda" wrote: I need to remove empty lines from a very large spreadsheet |
#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 "mdeanda" wrote: I need to remove empty lines from a very large spreadsheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
How do I remove the individual subtotal lines from a pivot table.. | Excel Discussion (Misc queries) | |||
how do I print grid lines for blank rows | Excel Discussion (Misc queries) | |||
how do I print grid lines for blank rows | Excel Discussion (Misc queries) | |||
Blank Spreadsheet (not really) | Setting up and Configuration of Excel |