remove blank lines from an entire spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
inserting lines throughout a spreadsheet 3
Lookups - how to obtain data from a master spreadsheet into another 5
Excel Excel Single to Double Line Spacing 2
Duplicate lines in spreadsheet 1
Remove Merge and Center for entire spreadsheet 3
need to input alternate blank rows in spreadsheet 5
formula finds values in apparently blank cells 1

Back
Top