SOLVED [Excel] Automatic font size reduction if data length exceeds column width?

[Neil Baxter]

Using a spreadsheet with set column widths, is it possible to decrease the font size if the length of the text being input becomes wider than the cell? This would save me the headache-inducing hassle of reducing the font size to fit after I have already entered the text. The text in this column normally doesn't exceed the width, but every so often I have an entry that is a bit long. There's no need for it to go the other way; once this particular entry is made, it will never need to be changed. Also, it doesn't need to be real-time (although that would be spiffy!) but as long as it all fits after I press tab/enter I'll be happy.

Thanks!

EDIT: *sigh* Obviously I didn't look hard enough when I first tried to find how to do this natively. Home ribbon>Number section>More Number Formats...>Alignment tab>[X] Shrink to fit