Hello all and welcome back to the Excel Tip of the Week. This week, we have a Basic User post in which we're going to look at a few options to help make text fit into a given space - including a neat and quite hidden option for shrinking the text to fit.
Scaling to fit
Ever had this problem? You have a column of a certain size and want to fit some text neatly in to it:
If you want this text to all be shown in the cell, you have a few options:
This fourth option is what we are going to investigate today - sometimes changing cell sizes or spilling into another cell isn't appropriate because it can mess up presentational or printing elements elsewhere.
Now, you could shrink the font size manually - but in fact there's an option to do this lurking in the 'Alignment' tab of the Cell Formatting menu. You can access this menu with Ctrl and 1 or Home => Format => Format Cells, or pop it out from the bottom right corner of any formatting-related subgroup on the Home menu.
Do that, and you will get a result like this:
And that's about it for shrink to fit!
Previous postTOTW index Next post
This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Filtered. There is also an online forum where you can ask questions and share ideas with other community members.