| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| Delete Empty Rows | Excel Discussion (Misc queries) | |||
| How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| how do i find and delete all empty rows in an excel worksheet | Excel Worksheet Functions | |||
Linear Mode
