| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting all but one blank row
I have a file created by another program that inserts six blank rows after
each row of data. The exported format is Excel 8.0 Extended (whatever that means). I found several really helpful suggestions how to delete all of the blankrows. The one to use the Go To Special command seems to be the easiest. Unfortunately, I want to keep one blank row as a divder between each data row. Any suggestions? -- I know enuff to be dangerous. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Blank Rows | New Users to Excel | |||
| Deleting Blank Cells Wholesale? | Excel Discussion (Misc queries) | |||
| Deleting Blank Characters in a Cell | Excel Discussion (Misc queries) | |||
| Deleting blank cells in a column | Excel Discussion (Misc queries) | |||
| Deleting rows with blank cells | Excel Worksheet Functions | |||
Threaded Mode
