View Single Post
  #2   Report Post  
Old November 25th 05, 01:58 AM posted to microsoft.public.excel.setup
Gord Dibben
 
Posts: n/a
Default 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?