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

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

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