Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting extra rows in Excel 07
I know there is an easier way to do this as opposed to manually deleting the
extra rows, but here is my situation. We have a large table, which for some reason was created in Word. When the table is copied into Excel, it is quite large (approx 1200 lines) and it appears to have inserted an extra line in most rows, although some cells appear to be merged, while others are not. The user can hit the CTRL button and manually select every row and delete, but I was hoping that there was a faster or easier method. thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting extra rows in Excel 07
Do you mean a blank row between rows?
F5SpecialBlanksOK EditDeleteEntire Row Might work depending upon what the "extra lines" in rows are. Gord Dibben MS Excel MVP On Thu, 25 Jun 2009 13:12:01 -0700, Nat wrote: I know there is an easier way to do this as opposed to manually deleting the extra rows, but here is my situation. We have a large table, which for some reason was created in Word. When the table is copied into Excel, it is quite large (approx 1200 lines) and it appears to have inserted an extra line in most rows, although some cells appear to be merged, while others are not. The user can hit the CTRL button and manually select every row and delete, but I was hoping that there was a faster or easier method. thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting extra rows in Excel 07
Absolutly brilliant Gord. thanks .. I can work with that.
Much appreciated. "Gord Dibben" wrote: Do you mean a blank row between rows? F5SpecialBlanksOK EditDeleteEntire Row Might work depending upon what the "extra lines" in rows are. Gord Dibben MS Excel MVP On Thu, 25 Jun 2009 13:12:01 -0700, Nat wrote: I know there is an easier way to do this as opposed to manually deleting the extra rows, but here is my situation. We have a large table, which for some reason was created in Word. When the table is copied into Excel, it is quite large (approx 1200 lines) and it appears to have inserted an extra line in most rows, although some cells appear to be merged, while others are not. The user can hit the CTRL button and manually select every row and delete, but I was hoping that there was a faster or easier method. thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Extra Page | Excel Discussion (Misc queries) | |||
Excel 2002: What happen to the extra rows and columns ? | Excel Discussion (Misc queries) | |||
Deleting Rows in MS Excel | Excel Discussion (Misc queries) | |||
How to compress an Excel file once deleting extra worksheets | Excel Discussion (Misc queries) | |||
limiting or deleting extra characters in a cell | Excel Discussion (Misc queries) |