Shrinking the text to fit within a cell

The second way of getting long text entries to fit within a certain cell width is to shrink their text down to size with the Shrink to Fit check box option. This option is a lot less successful than Wrap Text because Excel often ends up shrinking your text entries so much that they're illegible without the use of a magnifying glass.

Reserve the Shrink to Fit option to those text entries that almost fit within the current column width to guard against reducing them so much that they're no longer legible.