In Excel where text wraps in a cell, how can the row height be auto set?

hello experts.

I have set the  text wrap to auto in Excel 2007, to allow text wrap automatically.
However, once I am out of the cell only the top line of text shows. In other word the row's height does not adjust automatically to show  all the text in the cell.

How can I do that?
Thanks
tariqanisAsked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
Not sure if on Excel 2007 it's on the same place but on Excel 2010, you sould select the rows and on the Home tab, on the Cells group, you will find Format. Open the menu and AutoFir Row Height.

jppinto
0
 
redrumkevCommented:
tariganis,

See this link and then click the + sign below notes on how to set this to automatic:

http://office.microsoft.com/en-us/excel-help/wrap-text-in-a-cell-HP001216382.aspx

Hope this helps,
Kevin
0
 
jppintoCommented:
typo.... I meant "AutoFit", not "AutoFir"
0
 
tariqanisAuthor Commented:
Thank you. That was it.
0
All Courses

From novice to tech pro — start learning today.