The auto fit row height function

G

Guest

There are times when I attempt to resize the row height to fit the contents
of the cell but the auto fit does not do anything. I have checked to make
sure the wrap test box is checked and it is, but the row does not get any
bigger. Also, the wrapped portion of the text does not show in the cell but
does appear in the formula box. Any ideas?
 
P

Paul Lautman

Boomer said:
There are times when I attempt to resize the row height to fit the
contents of the cell but the auto fit does not do anything. I have
checked to make sure the wrap test box is checked and it is, but the
row does not get any bigger. Also, the wrapped portion of the text
does not show in the cell but does appear in the formula box. Any
ideas?
Click to expand...

Grab the macro AutoFitMergedCellRowHeight from
http://www.mrexcel.com/archive2/55800/64787.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fit contents 1
Row Height - Auto-Fit 1
Need help on formatting row height 1
Auto fit row height for one column 3
Rows expand to fit text typed in? 2
2007 Excel: text in cell becomes hidden when formatted to wrap tex 0
row height 1
How do I autofit row height to adjust to new text on Excel form? 1

Top