| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
expand row to fit
Is it possible to format a cell / row so that if the text in a cell is longer
than the width the text wraps and the row height expands to include the extra line(s)? Thanks, Peter. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
expand row to fit
FormatCellsAligmentWrap Text
FormatRowAutofit. Note: if cells are merged the row autofit won't work. Gord Dibben MS Excel MVP On Wed, 5 May 2010 15:06:01 -0700, Peter wrote: Is it possible to format a cell / row so that if the text in a cell is longer than the width the text wraps and the row height expands to include the extra line(s)? Thanks, Peter. |
|
#3
|
|||
|
|||
Quote:
Worksheets("Sheet1").Range("A1:A65000"). _ AutoFormat Format:=xlRangeAutoFormatClassic1 it will autoformat.
__________________
Thanks Bala |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expand a box | Excel Discussion (Misc queries) | |||
| Fill and expand | Excel Worksheet Functions | |||
| How do I expand a worksheet? | Excel Discussion (Misc queries) | |||
| Can cell expand to fit | Excel Discussion (Misc queries) | |||
| How do I expand the Name Box? | Excel Discussion (Misc queries) | |||
Hybrid Mode
