Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 25th 05, 01:26 AM posted to microsoft.public.excel.setup
Stevel
 
Posts: n/a
Default 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   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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Lines in Excel sibadee14 Excel Discussion (Misc queries) 1 November 16th 05 07:56 AM
Lines separating rows and columns won't unhide [email protected] Excel Discussion (Misc queries) 3 November 2nd 05 04:49 AM
Deleting multiple lines tammytlc Excel Discussion (Misc queries) 1 October 3rd 05 11:49 PM
Getting rid of random white lines in Excel lizzibet76 Excel Discussion (Misc queries) 2 September 27th 05 03:41 PM
Partial Grid Lines Keith-in-Indy Excel Discussion (Misc queries) 4 August 17th 05 06:55 PM


All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017