Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Fitting Text Into Cells.

Fitting Text Into Cells

Written by Allen Wyatt (last updated May 5, 2020)
This tip applies to Word 2007, 2010, 2013, and 2016


15

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:

  1. Select the cell or cells that you want to format.
  2. Make sure the Layout tab of the ribbon is displayed. (This tab is only visible if you first do step 1.)
  3. Click the Properties tool in the Table group. Word displays the Table Properties dialog box.
  4. Select the Cell tab. (See Figure 1.)
  5. Figure 1. The Cell tab of the Table Properties dialog box.

  6. Click on the Options button. Word displays the Cell Options dialog box. (See Figure 2.)
  7. Figure 2. The Cell Options dialog box.

  8. Make sure the Fit Text check box is selected.
  9. Click on OK to close the Cell Options dialog box.
  10. Click on OK to close the Table Properties 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:

If you would like to know how to use the macros described on this page (or on any other page on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

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.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Printing a Draft of a Document

Need to print a copy of a document but you don't care if it looks as "pretty" as you want the final printout to look? You ...

Discover More

Error Using ATAN2 Function in Macro

Excel allows you to use worksheet functions from within macros. This is helpful, especially when you are trying to ...

Discover More

Extra Space after Quotation Mark when Pasting

Have you ever noticed how Word can decide to add extra spaces when you paste information into your document? This is part ...

Discover More

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!

More WordTips (ribbon)

Changing Cell Alignment

Individual cells in a table can be aligned any way you desire. As pointed out here, just select the cell and apply the ...

Discover More

Right Aligning a Table Column with an Indent

Word allows you to get a bit fancy in formatting the alignment of your tables. In this tip, you discover how to enter ...

Discover More

Centering Information in Table Cells

One of the most common ways to format information in a table is to apply some sort of alignment to the contents of table ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 2 + 2?

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

Allen

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

Roger

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?¿?


This Site

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.

Videos
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.