Shrink text to fit the cell

Save time, let Leo do it for you!

Leo helps organizations by providing unparalleled and innovative help and support on Microsoft Office 2007 and 2010 applications.

Get Leo for your organization to:

  • Reduce deployment, adaptation time and training costs for new software
  • Decrease dependence on your help desk
  • Minimize loss of productivity


Reduce the apparent size of font characters in a selected cell so that all the data can fit within the column. The character size on the worksheet will adjust automatically if you change the column width, whereas the actual font size will remain unchanged.

Topic: Office 2007 /Excel /Alignment

Shrink text to fit the cell Microsoft Excel 2007  1
  • Select the cells whose text you want to shrink to fit the cell.
  • Click
Shrink text to fit the cell Microsoft Excel 2007  2
  • Click
Shrink text to fit the cell Microsoft Excel 2007  3
  • Click
Shrink text to fit the cell Microsoft Excel 2007  4
  • Click
Shrink text to fit the cell Microsoft Excel 2007  5
  • Select the Shrink to fit check box.
  • Click

Tags: , , , ,