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

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

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