Excel will not show all text entered in a Cell merged from 9 rows

[Pat]

I have tried to autofit and format cell, but nothing works. I have to
manually drag the cell border to make it longer.

 

[Paul Black]

Hi Pat,

Have you Also Tried Wrap Text.

All the Best.
Paul

 

[Pat]

Yes, that was the first thing.

 

[Dave Peterson]

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?threadm=e1$1uzL1BHA.1784@tkmsftngp05

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]

Thanks. I will try it.

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?threadm=e1$1uzL1BHA.1784@tkmsftngp05

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]

I ran your macro and it doesn't do anything. Should I be blocking something
out?

 

[Dave Peterson]

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?