View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bassman62 Bassman62 is offline
external usenet poster
 
Posts: 117
Default Row Height-expand if text wraps in a cell

Penny,

Make sure the Rows have been formatted to "Autofit Row Height". Select rows
then on the Home tab, Format...
Hope this helps.

Dave

"Penny Miller" wrote in message
...
I have a worksheet that has a comments column that is formatted to wrap
text if needed for each cell. My problem is I need the row to
automatically adjust to the height of what ever is entered in that cell.

Using Excel 2007