Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Deleting unused lines between used lines?
How do I delete unused lines between used lines? I imported a group of email
addresses into an Excel file and about 10500 lines were used. However, many of those lines are empty. How do I eximinate all of the unused lines, that is, "compress" all of the email addresses so that no unused lines are between them? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Deleting unused lines between used lines?
Steve
Select a column. F5SpecialBlanksOK EditDeleteEntire RowOK Gord Dibben Excel MVP On Thu, 24 Nov 2005 16:26:04 -0800, Stevel wrote: How do I delete unused lines between used lines? I imported a group of email addresses into an Excel file and about 10500 lines were used. However, many of those lines are empty. How do I eximinate all of the unused lines, that is, "compress" all of the email addresses so that no unused lines are between them? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Lines in Excel | Excel Discussion (Misc queries) | |||
Lines separating rows and columns won't unhide | Excel Discussion (Misc queries) | |||
Deleting multiple lines | Excel Discussion (Misc queries) | |||
Getting rid of random white lines in Excel | Excel Discussion (Misc queries) | |||
Partial Grid Lines | Excel Discussion (Misc queries) |