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.
Step 3: Click the Home tab at the top of the window.
Step 4: Click the small Font Settings button at the bottom-right corner of the Font section of the ribbon.
Step 5: Click the Alignment tab.
Step 6: Select the Shrink to Fit option, then click the OK button.
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.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.