All Things Newz
Technology

How to Shrink Text to Fit a Cell in Microsoft Excel


Microsoft Excel logo on a green background

Sometimes you want your Excel spreadsheet to have a good appearance in addition to displaying the data. Rather than wrapping text in a cell or adjusting a cell’s size to accommodate the text, you can shrink the text to fit.

Let’s look at the advantages of using the shrink text feature and how to use it in Microsoft Excel on Windows and Mac.

Benefits of Shrinking Text in Excel

Here are a few reasons to use Excel’s shrink text feature.

How to Shrink Text in Excel on Windows

In Excel on Windows, select one or more cells containing the text you want to shrink. Go to the Home tab and click the arrow in the bottom right corner of the Alignment section of the ribbon.

Selected cells and Alignment arrow in Excel

Check the box for Shrink to Fit in the Text Control section of the window and click “OK.”

Shrink to Fit box checked

You’ll then see your change with the text sized to fit within the cell.

Text fits within the cells

If you change your mind later and want to undo the shrink you applied, simply follow the same steps above and uncheck the Shrink to Fit box.

How to Shrink Text in Excel on Mac

In Excel on Mac, select one or more cells containing the text you want to shrink. Go to the Home tab and click the arrow next to the Wrap Text button in the Alignment section of the ribbon. Choose “Shrink Text to Fit.”

Shrink to Fit in the Wrap Text drop-down menu

You should then see the text in the selected cell(s) update to fit inside.

Text fits within the cells

If you want to return the text to its original size, follow the same steps as above and select “Shrink Text to Fit” to remove the checkmark.

For an easy, time-saving way to make text fit perfectly inside a cell, remember this shrink text feature in Excel.

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






Source link

Related posts

How to Set Up Facebook Marketplace Alerts

Chevy Bolt EV Owners Get a Rebate If They Promise Not to Sue – Review Geek

Is Apple Killing the iPhone Mini?