-----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]
.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.
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]
.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.