Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Catherine@rhpc
 
Posts: n/a
Default How do I get rid of spare lines in an excel spread sheet?

I have down loaded a list from another source which has two extra lines
between entries - I wish to shrink the spread sheet to only include the
necessary data I am a novice at excel and find it daunting. please make the
answer easy to follow. Thank you
  #2   Report Post  
Dave R.
 
Posts: n/a
Default

The solution might depend on if there are 2 extra lines in total, or if
there are 2 extra lines after each piece of useful data.

You can delete the entire row by going to editdelete..entire row.

Or you can select the cells that you want deleted and delete them the same
way but you'll have to decide whether to shift cells to fill the deleted
cells either UP or to the LEFT.

If you have 2+ columns that contain data that must stay together, be sure to
select a cell from each column to keep the data together.

If you have 2 extra lines here and there, you can also sort the data (select
all of it; datasort) and it will consolidate all of the similarly blank
lines.




"Catherine@rhpc" wrote in message
...
I have down loaded a list from another source which has two extra lines
between entries - I wish to shrink the spread sheet to only include the
necessary data I am a novice at excel and find it daunting. please make

the
answer easy to follow. Thank you



  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Catherine

Select Column A and F5SpecialBlanksOK

Now with blanks selected from above operation, EditDeleteEntire Rows

Gord Dibben Excel MVP

On Mon, 6 Dec 2004 15:25:07 -0800, "Catherine@rhpc"
wrote:

I have down loaded a list from another source which has two extra lines
between entries - I wish to shrink the spread sheet to only include the
necessary data I am a novice at excel and find it daunting. please make the
answer easy to follow. Thank you


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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 12:46 PM
How do I export excel spread sheet to my Palm T3? loki Excel Discussion (Misc queries) 1 February 14th 05 09:21 PM
in excel, how do i set up a spread sheet that automatically total. jgus New Users to Excel 1 January 14th 05 05:10 AM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 10:03 PM
balance sheet template in excel adding lines JMJM Excel Discussion (Misc queries) 1 December 2nd 04 12:23 AM


All times are GMT +1. The time now is 06:11 AM.

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

About Us

"It's about Microsoft Excel"