How to use Shrink to Fit in Excel

Learn how to use the "Shrink to Fit" feature in Excel. Dates and numbers that don't fit in a cell are displayed as ######. Using Shrink to Fit, Excel will reduce the font size automatically to fit within the cell.
0:03 The ###### problem in Excel
0:13 Applying Shrink to Fit to fix the problem
0:40 When to use Shrink to Fit (4 reasons)
👍Remember to Subscribe!
FOLLOW VERTEX42 HERE:
Instagram: / vertex42
Facebook: / vertex42
Pinterest: / vertex42
Twitter: / vertex42
Website: www.vertex42.com/
MUSIC: Funster, by Young Rich Pixies, licensed via ArtList

[@santoshupadhyay4557]

Thank you sir for your time.

[@easterneuropeaninmexico3554]

Please, don’t stop uploading and sharing your knowledge! Your videos are gold!

[@smasa8542]

Tqvm for this tips. I've been looking for this function without knowing the key word for it, by randomly searching like; "how to auto change font size in excel"😅 .
Really appreciate, how you also show the other cell/text adjustment options available in a very compact n clear way.

[@artinegi5348]

Thank you

[@katz3ye]

is there a control key for that? because this is good if your dealing with 1 or 3 but im dealing with 1000 or more

[@marko49972]

Where is that option in Online Office 365 version?