| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically adjusting Row height
I have a spreadsheet that has a merged cell that allows text wrapping. When
I type quite a bit of text into the cell it may fill up the cell and I cannot see all the text. I would like to have the row automatically increase its height (rather than use the menu Format -- Row --Height) so that all the data can be seen. Ideally the height would be automatically adjusted when I leave the cell. Can this be done and if so how. Thanks in advance for any help. Joe |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically adjusting Row height
If you want to use merged cells you will have to employ VBA event code to
autofit the row height. See this google search. http://tinyurl.com/2uhkdj Gord Dibben MS Excel MVP On Mon, 26 Nov 2007 13:46:04 -0800, JoeP wrote: I have a spreadsheet that has a merged cell that allows text wrapping. When I type quite a bit of text into the cell it may fill up the cell and I cannot see all the text. I would like to have the row automatically increase its height (rather than use the menu Format -- Row --Height) so that all the data can be seen. Ideally the height would be automatically adjusted when I leave the cell. Can this be done and if so how. Thanks in advance for any help. Joe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adjusting row height to accomidate text in a cell | Excel Discussion (Misc queries) | |||
| Linked spreadsheet is not automatically adjusting row height? | Excel Discussion (Misc queries) | |||
| Automatically Adjusting Row Height in Merged Cells | Excel Discussion (Misc queries) | |||
| Automatically adjusting columns | Excel Discussion (Misc queries) | |||
| Row height is not adjusting after activating Merge Cells & Wrap Te | Excel Worksheet Functions | |||
Linear Mode
