Deleting extra rows in Excel 07

N

Nat

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
 
G

Gord Dibben

Do you mean a blank row between rows?

F5>Special>Blanks>OK

Edit>Delete>Entire Row

Might work depending upon what the "extra lines" in rows are.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help deleting data 2
I cannot delete the extra rows or columns in Excel 2007 2
'07 Large Operation Error (Delete / Insert Rows and/or Columns) 3
Excel macro to copy rows in one sheet and insert into another sheet 5
Deleting 63,886 Blank Rows Under My Data 15
Deleting rows in Excel 2007 using filters 1
Inserting Rows...but losing "FORMAT" 1
How can I remove extra space when using autofit in Excel 2003? 3

Top