Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I export excel spread sheet to my Palm T3? | Excel Discussion (Misc queries) | |||
in excel, how do i set up a spread sheet that automatically total. | New Users to Excel | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
balance sheet template in excel adding lines | Excel Discussion (Misc queries) |