How to have a cell auto resize the font to make text fit in cell?

  • Follow


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.  
0
Reply Utf 5/21/2010 6:50:01 PM

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
0
Reply Dave 5/21/2010 6:59:31 PM

1 Replies
1834 Views

(page loaded in 0.034 seconds)


Reply: