ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   The auto fit row height function (https://www.excelbanter.com/excel-discussion-misc-queries/93722-auto-fit-row-height-function.html)

Boomer

The auto fit row height function
 
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?

Paul Lautman

The auto fit row height function
 
Boomer wrote:
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?


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



Boomer

The auto fit row height function
 
I'll try that but the cell is not merged, thanks anyway

"Paul Lautman" wrote:

Boomer wrote:
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?


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





All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com