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 post - Breaking linksTOTW index Next post - Paste Special redux
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.