Written by Allen Wyatt (last updated May 5, 2020)
This tip applies to Word 2007, 2010, 2013, and 2016
You have worked long and hard on your page design, including a couple of tables that are just right. Then, along comes a need to add a bit more text into one of the tables. The result is that the text in a cell wraps and pushes everything else down a bit. Now your whole design is thrown off. You long for a way to automatically adjust the size of the text in a cell so you won't have the wrapping and pushing occur.
Word provides a built-in option that may do the trick. Simply follow these steps:
Figure 1. The Cell tab of the Table Properties dialog box.
Figure 2. The Cell Options dialog box.
What Word does is to decrease the apparent size of the text so that everything fits. Word decreases the width of the text by "scrunching" (a highly technical term) the text together horizontally, without adjusting it vertically.
Note:
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (6081) applies to Microsoft Word 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Word here: Fitting Text Into Cells.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Individual cells in a table can be aligned any way you desire. As pointed out here, just select the cell and apply the ...
Discover MoreWord allows you to get a bit fancy in formatting the alignment of your tables. In this tip, you discover how to enter ...
Discover MoreOne of the most common ways to format information in a table is to apply some sort of alignment to the contents of table ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-08-17 19:15:28
pizza
Way too useful, thank you! Solved the messed up table formatting in our school document in a minute :)
2021-04-13 10:39:43
BarbaraK
This works perfectly if your text is too long, but if your text is shorter than the cell width, Word expands the spacing, which is really obnoxious to read.
Is there a solution if you want Word to *only* scrunch the text if it would normally wrap, but *not* expand the text if it's shorter than the cell width?
(see Figure 1 below)
Figure 1.
2021-04-03 03:22:25
Vera
You are THE MASTER! I really appreciate your knowledge and you are my go to person for EVERYTHING Word!!! Thank you for sharing :)
2021-03-19 06:31:46
Jim Varsos
Hello Mr. Wyatt,
Thank you very much for the accurate answer, exactly what i wanted to fit my text into the table cells with a minimum left intend of 0,1cm.
MSc, Electrical Eng. Jim Varsos
2018-01-25 11:38:48
Ludo - Note the last paragraph in the tip, above. Word adjusts the width of the text horizontally only; it does not adjust the height of the text vertically.
-Allen
2018-01-25 11:27:48
Ludo Soete
Dear Mr. Wyatt,
I tried your sugestion to fit text into a cell, but this is not always working.
I'm using Word 2010.
I placed an address in the cell, see picrure, with a font size too large to fit in the cell, and hoped with the tip T006081_Fitting_Text_Into_Cells.html that i could resize the text to fit entirely in the cell, but as you can see, it doesn't fit at all.
the idea behind it is to place text into table cells (adhesive labels) with a larger font than it should be, and afterwards resize it to fit in the cell.
cells differ according to the selected labels used, so a 'autofit' could be the way to do it, but no luck.
Is there an other solution for this issue?
best regards,
Ludo
(see Figure 1 below)
Figure 1.
2017-10-12 21:54:24
Vince
I'm creating a table with short width cells, however it won't let me type in more than 1 character, it just adds the additional characters vertically downward. Even if I stretch the width of the cell to about 1", the additional text begins wrapping about a 1/2" from the right side of the cell. Any idea how to adjust the cell to add more text?
2016-09-14 04:31:08
Michael
This doesn't work
2016-08-30 03:19:48
this tip does not work for Office 365 there is no auto fit text to cell option
2016-07-26 10:55:07
Elaine Doga
I would like the text to shrink but also wrap around in the cell rather than continuously keep shrinking. The fit text seems to over-ride the wrap option. Any ideas?
2016-06-11 05:59:58
Beth
I have used pdf forms and that function is available, also, but this one needs to be in Word. Just can't quite come up with the process to keep a properly formatted document once it is sent to users.
2016-06-10 06:46:18
Paul Franklin Stregevsky
In other words, Beth, you'd like a way to make the text "shrink to fit" the way it shrinks automatically in PowerPoint. Interesting idea.
2016-06-09 09:38:30
Beth
This is almost what I need, but not quite. I have a template with a question at the top of each section, and I want users to type their answers in the space below. The text should wrap as they type and keep normal formatted font/size if they stay within the box limits. If text runs too long, I want it to shrink the font size of everything they have written to stay within the box and not stretch the box.
2016-05-11 21:11:02
Pete A
It DOES reduce the size of text that is too long for a table cell It ALSO spreads out text that is "too short" for a table cell, giving something like this:
T o o S h o r t
Need to just scrunch the long ones to fit, but don't mess with the ones that DO fit.
Thanks for the good writeup
2016-04-02 07:41:21
pete
If set-width is so great... can I start the process over again... and create msg. with less characters?¿?
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2023 Sharon Parq Associates, Inc.
Comments