When you type a long sentence into a single cell in Microsoft Excel, the text naturally spills over the right edge of the cell into the adjacent column. If you don’t want the text to spill, you can apply a specific formatting rule called “Shrink to Fit.” When this is enabled, Excel will automatically and dynamically reduce the font size of your text until the entire sentence fits perfectly within the physical boundaries of the column.
While this sounds like a clever way to keep a spreadsheet organized without adjusting column widths, it creates a massive readability problem. If you paste a paragraph into a cell that is only two inches wide, Excel will violently shrink the font size down to 2pt or 3pt, rendering the text completely illegible to the human eye without zooming in.
If you prefer your text to remain at a readable 11pt font—even if it means the text gets cut off visually—you must disable the “Shrink to Fit” property.
How to Turn Off Shrink to Fit
This setting is controlled on a per-cell basis through the Alignment formatting menu.
- Open your spreadsheet in Microsoft Excel.
- Highlight the cell (or click and drag to highlight the entire column) that is currently shrinking your text.
- Right-click anywhere inside your highlighted selection.
- Click on Format Cells… from the pop-up context menu.
- In the Format Cells dialog box, click on the Alignment tab at the top.
- Look in the section labeled “Text control.”
- You will see three checkboxes. Look for the one labeled Shrink to fit.
- Click the checkbox to uncheck it. (If the box is currently filled with a solid black square instead of a checkmark, it means some of your selected cells have the feature on, and some have it off. Click it twice until the box is completely empty).
- Click the OK button at the bottom of the window.
Your text will instantly snap back to its default font size (e.g., Calibri 11pt). If the text is now spilling into the next column, you can either widen the column manually or check the “Wrap text” box in the exact same formatting menu to force the cell to expand downward instead.