Delete empty rows in a worksheet

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

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.
 
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]
 
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.
Click to expand...
.
Click to expand...
 
No problem, Scott - happy to help!

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

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

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.
Click to expand...
.
Click to expand...
Click to expand...
 
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

Count latest number of continous not-empty cells in a row. 11
Deleting rows in multiple worksheets 5
Delete Empty Rows Macro 6
Speeding up a delete rows Macro 6
Delete Empty Rows Macro 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Load a CSV into an empty, formatted XLS? 15
Deleting Empty Rows 5

Back
Top