If you hit ctrl-a (twice in xl2003), you select all the cells.

Now try double clicking on line between the row numbers on the row header (to
the far left).

Or just format|row|autofit
(with all the rows selected)

Dee wrote:

I have a Word table that I need to paste into Excel. When I paste, the length
of the rows of the table are much larger than they were in the Word table. I
can double click on the row to make them the default size but I have to do
each one separately. Is there a way to make the rows go to the default size
all at once? I am using Excel 2002.

Thank you for any help.

Best regards

Dee

--

Dave Peterson