free counter
Science And Nature

How exactly to Shrink Text to match a Cell in Microsoft Excel

Microsoft Excel logo on a green background

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.

Great things about Shrinking Text in Excel

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.

How exactly to Shrink Text in Excel on Windows

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.

Selected cells and Alignment arrow in Excel

Check the box for Shrink to squeeze in the written text Control portion of the window and click OK.

Shrink to Fit box checked

Youll then see your change with the written text sized to fit well within the cell.

Text fits within the cells

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.

How exactly to Shrink Text in Excel on Mac

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.

Shrink to Fit in the Wrap Text drop-down menu

You need to then start to see the text in the selected cell(s) update to match inside.

Text fits within the cells

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.

RELATED: How exactly to Set Row Height and Column Width in Excel

Read More

Related Articles

Leave a Reply

Your email address will not be published.

Back to top button

Adblock Detected

Please consider supporting us by disabling your ad blocker