But when you can’t change the size of a cell to fit the text, this tip shows how you can resize the text to fit within the cell. SEE: Explore these Excel tips every user should master .

An Excel sheet with an arrow indicating where to double-click to change column width. The AutoFit Column Width in Excel's Format drop-down in the Home tab is selected.

1. Select the cell with text that’s too long to fully display, and press [Ctrl]1. 2. In the Format Cells dialog box, select the Shrink To Fit check box on the Alignment tab, and click OK.