| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I make the cell expand to fit my text as I type?
I merged some cells across the width of a spreadsheet and i can't get the
cell to increase it's height as more text is typed in wraps around. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I make the cell expand to fit my text as I type?
Only way I know, is to move your cursor to between the row number of therow
you want to adjust and the next row. The cursor changes shape into an up/down arrow. Click and drag till you see all. Double clicking will also not work "pnwwoman" wrote: I merged some cells across the width of a spreadsheet and i can't get the cell to increase it's height as more text is typed in wraps around. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I make the cell expand to fit my text as I type?
If cells are merged. the row will not autofit without using VBA
See google search thread for code by Greg Wilson http://groups.google.com/group/micro...1c160cbeb27874 Gord Dibben MS Excel MVP On Sat, 23 Sep 2006 00:03:01 -0700, pnwwoman wrote: I merged some cells across the width of a spreadsheet and i can't get the cell to increase it's height as more text is typed in wraps around. Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find specific text and make cell highlighted | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Cell Capacity - text | Excel Discussion (Misc queries) | |||
| How make text appear in a cell as a result of a number in another | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Hybrid Mode
