| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row Height-expand if text wraps in a cell
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Row Height-expand if text wraps in a cell
I have tried the "Autofit Row Height" and it is not working. Am I supposed
to be selecting a certain area for this to work? The "Autofit Column Height" works but not for rows...any tips? "Bassman62" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Row Height-expand if text wraps in a cell
Selah
Do you have any merged cells in your range? These disable the Row Autofit when set to wrap text. Either get rid of them or you will have to use VBA event code. Gord Dibben MS Excel MVP On Wed, 24 Jun 2009 13:42:01 -0700, "Selah West" wrote: I have tried the "Autofit Row Height" and it is not working. Am I supposed to be selecting a certain area for this to work? The "Autofit Column Height" works but not for rows...any tips? "Bassman62" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where text wraps in a cell, how can the row height be auto set? | Excel Worksheet Functions | |||
| How do I set a cell to automatically adjust it height to expand | Excel Discussion (Misc queries) | |||
| Use autofit to row height.But row does not expand 2 cover content | Excel Worksheet Functions | |||
| Not all text wraps in a cell containing large amount of text | Excel Discussion (Misc queries) | |||
| Expand height of chart? | Charts and Charting in Excel | |||
Linear Mode
