Select the range to format
hit ctrl-1 (ctrl-one key)
Alignment tab
Click shrink to fit

(I bet that you can find the formatting option somewhere on that ribbon!)

tanner08 wrote:

I'm using Office 2007, and I would like to know how to make the font size
automatically adjust to fit whatever I type into an individual cell.

--

Dave Peterson