Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel will not show all text entered in a Cell merged from 9 rows
I have tried to autofit and format cell, but nothing works. I have to
manually drag the cell border to make it longer. |
#2
|
|||
|
|||
Hi Pat,
Have you Also Tried Wrap Text. All the Best. Paul |
#3
|
|||
|
|||
Yes, that was the first thing.
"Paul Black" wrote: Hi Pat, Have you Also Tried Wrap Text. All the Best. Paul |
#4
|
|||
|
|||
Autofitting rowheight and merged cells don't play nice.
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 Pat wrote: I have tried to autofit and format cell, but nothing works. I have to manually drag the cell border to make it longer. -- Dave Peterson |
#5
|
|||
|
|||
Thanks. I will try it.
"Dave Peterson" wrote: Autofitting rowheight and merged cells don't play nice. 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 Pat wrote: I have tried to autofit and format cell, but nothing works. I have to manually drag the cell border to make it longer. -- Dave Peterson |
#6
|
|||
|
|||
I ran your macro and it doesn't do anything. Should I be blocking something
out? "Dave Peterson" wrote: Autofitting rowheight and merged cells don't play nice. 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 Pat wrote: I have tried to autofit and format cell, but nothing works. I have to manually drag the cell border to make it longer. -- Dave Peterson |
#7
|
|||
|
|||
This portion of Jim's code does some checking:
If ActiveCell.MergeCells Then With ActiveCell.MergeArea If .Rows.Count = 1 And .WrapText = True Then Is your activecell part of a merged area? Is that mergearea a single row? Do you have wraptext turned on? Pat wrote: I ran your macro and it doesn't do anything. Should I be blocking something out? "Dave Peterson" wrote: Autofitting rowheight and merged cells don't play nice. 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 Pat wrote: I have tried to autofit and format cell, but nothing works. I have to manually drag the cell border to make it longer. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
When printing using Excel the text does not fit in the cell | Excel Discussion (Misc queries) | |||
How I do I rotate text in an excel cell? The rotate commands is g. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |