To shrink text to fit a cell in Excel, select the cells, press Ctrl + 1, open the Alignment tab, check Shrink to fit, and click OK. When text is too long for its cell, Excel either spills it into the next cell or cuts it off. Shrink to fit automatically reduces the font size so everything fits inside the cell’s current width.
Shrinking text is not the only fix, since you can also make the cell longer by changing the column width.

Turn On Shrink to Fit
- Select the cell or range.
- Press Ctrl + 1, or right-click and choose Format Cells. You can also click the small arrow at the bottom right of the Alignment group on the Home tab.
- On the Alignment tab, under Text control, check Shrink to fit.
- Click OK.
The font scales down as needed. If you widen the column later, the text grows back toward its original size.
If the text is too long to shrink without becoming hard to read, wrap the text in Excel so it fills several lines inside the cell instead.
Shrink to Fit vs. Wrap Text vs. AutoFit
| Option | What it does | Best for |
|---|---|---|
| Shrink to fit | Reduces font size to fit the cell width | Fixed-width layouts, forms, printouts |
| Wrap text | Splits text into multiple lines and increases row height | Long descriptions and notes |
| AutoFit column width | Widens the column to fit the longest entry | Keeping font size consistent |
Wrap text and Shrink to fit can’t be used together; checking Wrap text grays out Shrink to fit.
AutoFit Instead
- Double-click the right border of the column letter to fit the column to its contents.
- Or go to Home > Format > AutoFit Column Width.
Apply to a Whole Column or Sheet
Click a column letter, or the Select All triangle for the whole sheet, then turn on Shrink to fit. To reuse the setting, use Format Painter or create a cell style with Home > Cell Styles > New Cell Style.
Limitations
- Very long text becomes unreadably small. Combine with a wider column or wrap text instead.
- The displayed font size doesn’t change in the Font Size box; Excel scales it only visually.
- Shrink to fit doesn’t work on merged cells in all cases, and it has no effect on numbers that show as ##### because the column is too narrow for the number format.
- In Excel for the web, the option may not appear; apply it in the desktop app.
Excel for Mac
Select the cells, press Command + 1, open Alignment, and check Shrink to fit.
Is there a Google Sheets equivalent?
No direct one. Use Format > Wrapping > Clip or Wrap, or resize columns.

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.