resize all rows in the spreadsheet to fit the text?

[the church lady]

I have an existing spreadsheet created by another user.

Some of the rows are not automatically sized to display all text.

Is there a command to resize all rows in the spreadsheet to fit the
text?

thanks
email: softwaretest underscore 2003 at hotmail

 

[Paul B]

Church lady, try Ctrl a, to select the whole sheet, then format, row,
autofit

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **