Sometimes you need your Excel spreadsheet to possess a good appearance along with displaying the info. Instead of wrapping text in a cell or adjusting a cells size to support the text, it is possible to shrink the written text to match.
Lets consider the benefits of utilizing the shrink text feature and how exactly to utilize it in Microsoft Excel on Windows and Mac.
Below are a few reasons to utilize Excels shrink text feature.
- It is possible to save time by avoiding trying different font sizes to have the text to match in the cell.
- In the event that you change the font size or style in your sheet or for selected cells, those cells you apply the shrink to wthhold the smaller size to match the cells.
- It is possible to keep your cells and columns the size you need without sacrificing appearance by making them larger to match the written text.
- In the event that you adjust the cell size once you shrink the written text, that text will adjust its size to match the cell.
In Excel on Windows, select a number of cells containing the written text you would like to shrink. Visit the Home tab and click on the arrow in underneath right corner of the Alignment portion of the ribbon.
Check the box for Shrink to squeeze in the written text Control portion of the window and click OK.
Youll then see your change with the written text sized to fit well within the cell.
In the event that you change your brain later and desire to undo the shrink you applied, simply follow exactly the same steps above and uncheck the Shrink to match box.
In Excel on Mac, select a number of cells containing the written text you would like to shrink. Visit the Home tab and click on the arrow close to the Wrap Text button in the Alignment portion of the ribbon. Choose Shrink Text to match.
You need to then start to see the text in the selected cell(s) update to match inside.
If you need to return the written text to its original size, follow exactly the same steps as above and choose Shrink Text to match to eliminate the checkmark.
For a straightforward, time-saving solution to make text fit perfectly in the cell, remember this shrink text feature in Excel.