Shrinking text to fit the cell
The font size of the data in a cell can automatically adjust to fit in a cell. To do this, select the Shrink to fit cell option in the Format Cells dialog. The figure below shows the results.
Shrinking font size to fit cells