Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am working on a template which by nature will require varying amounts of
text to be inputted. I can get the row to automatically expand as long as the cell is singular and not merged with other cells - but in order for the template design to work I have to merge cells together from the same row. I have tried formating the cells to shrink to fir, wrap text etc and I have tried autofit too but this has not worked. Any suggestions? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You have to adjust that manually (or via a macro).
Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like: http://groups.google.com/groups?thre...%40tkmsftngp05 If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Michelle Bance wrote: I am working on a template which by nature will require varying amounts of text to be inputted. I can get the row to automatically expand as long as the cell is singular and not merged with other cells - but in order for the template design to work I have to merge cells together from the same row. I have tried formating the cells to shrink to fir, wrap text etc and I have tried autofit too but this has not worked. Any suggestions? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
why can't i enter text into merged cells in excel | Excel Worksheet Functions | |||
How do I automatically expand a merged cell with wrapped text? | Excel Discussion (Misc queries) | |||
automatically fit an image into merged cells | Excel Discussion (Misc queries) | |||
Excel merged cell - can it automatically expand as text is typed? | New Users to Excel | |||
How do I "Wrap Text" & "Autofit" within Merged Cells in Excel? | Excel Worksheet Functions |