Excel wrap text and auto fit font

Copper Contributor

Hello,

 

I'm wondering if what I would like to do is possible. 

 

I have merged and centered one big cell (spans from A-L + 1-8). If I enter a text to appear that is too long to fit I would like it to wrap text but at the same time I want the font of the text to shrink/enlarge to fit the cell as much as possible. 

 

I have wrap text on, but then have to manually change my font size myself it that is still too big or too small. 

1 Reply

@tmarais 

I fear you're out of luck. If you turn on Wrap Text, Shrink to Fit will be disabled. So it'll be a manual process.