Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Shrink the Text in Excel Cells to Fit the Column Width

Date:2019-8-27 Author:Olivia

When the text is too long to be fully displayed in an Excel cell, you can use AutoFit feature to enlarge the cell to fit the contents, but it could result in too much blank space in the rest of the row and does not meet the requirements for files in a specific format. Here I will share the tip of how to shrink text to fit the cell when you don’t want to change the column width.

1. First, select the whole row on the worksheet.

How to Shrink the Text in Excel Cells to Fit the Column Width

2. Next, go to Home tab, and click Format in Cells group, select Format Cells under Protection.

How to Shrink the Text in Excel Cells to Fit the Column Width

How to Shrink the Text in Excel Cells to Fit the Column Width

3. A Format Cells dialog box will display, go to Alignment tab and check the box of Shrink to fit under Text control.

How to Shrink the Text in Excel Cells to Fit the Column Width

4. Simply hit OK, and now you will see all the titles are shrank to fit the cell.

How to Shrink the Text in Excel Cells to Fit the Column Width

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *