How to Shrink Text to Fit Inside a Cell in Excel 2013

When data inside the cells of an Excel spreadsheet overlap, then some of the data can be hidden. For certain types of use cases in Excel, this is not an issue. However, when being able to actually see all of the information in a spreadsheet is important, it can be frustrating when you discover that some of that information is not visible because the amount of data in the cell was too much to be displayed properly.

One way to fix this problem is to use a setting called Shrink to Fit. This will cause Excel to automatically adjust the size of the font in a cell so that all of the data in that cell can be seen. You can follow the steps below to apply the Shrink to Fit setting in an Excel 2013 cell.


How to Use the Shrink to Fit Option for a Cell in Excel 2013

The steps below are going to apply a formatting option to a cell of your choosing in an Excel 2013 spreadsheet. Once you complete these steps, then content that you enter into a cell will shrink in size so that all of that content remains visible. Note that this can result in extremely small text.

Step 1: Open your spreadsheet in Excel 2013.


Step 2: Select the cell to which you would like to apply the Shrink to Fit formatting.

select the cell to shrink to fit



Step 3: Click the Home tab at the top of the window.

click the home tab



Step 4: Click the small Font Settings button at the bottom-right corner of the Font section of the ribbon.

open the font settings menu



Step 5: Click the Alignment tab.

click the alignment tab



Step 6: Select the Shrink to Fit option, then click the OK button.

how to shrink to fit in excel 2013



Is your spreadsheet not printing the way that you would like? Learn about some Excel printing tips that can relieve some of the frustration that is typically associated with printing in Excel.