Delete empty rows in a worksheet
 

I've imported some data from a text file that
unfortunately was double-spaced. This has created empty
rows in my spreadsheet, which are far too numerous to
delete manually. I'm hoping someone can help me.

Delete empty rows in a worksheet
 

Hi Scott,

If you don't mind sorting your data, then it's pretty easy:

1) Select all cells
2) Select Data | Sort...

That will cause all non-empty cells to "float" to the top.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Scott wrote:
I've imported some data from a text file that
unfortunately was double-spaced. This has created empty
rows in my spreadsheet, which are far too numerous to
delete manually. I'm hoping someone can help me.

Delete empty rows in a worksheet
 

Scary how simple some solutions can be. Thanks so much.

Scott

-----Original Message-----
Hi Scott,

If you don't mind sorting your data, then it's pretty
easy:

1) Select all cells
2) Select Data | Sort...

That will cause all non-empty cells to "float" to the top.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address
unmonitored]


Scott wrote:
I've imported some data from a text file that
unfortunately was double-spaced. This has created empty
rows in my spreadsheet, which are far too numerous to
delete manually. I'm hoping someone can help me.
.

Delete empty rows in a worksheet
 

No problem, Scott - happy to help!

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Scott wrote:
Scary how simple some solutions can be. Thanks so much.

Scott

-----Original Message-----
Hi Scott,

If you don't mind sorting your data, then it's pretty easy:

1) Select all cells
2) Select Data | Sort...

That will cause all non-empty cells to "float" to the top.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Scott wrote:
I've imported some data from a text file that
unfortunately was double-spaced. This has created empty
rows in my spreadsheet, which are far too numerous to
delete manually. I'm hoping someone can help me.
.