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

by Allen Wyatt
(last updated April 2, 2016)

11

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

Arranging Document Windows

When you have multiple documents open at the same time, you need a way to control how those document windows appear on ...

Discover More

Running a Macro when a Worksheet is Deactivated

When you change from one worksheet to another, you may want to have Excel automatically run a macro for the worksheet you ...

Discover More

Excel Custom Formats

The fundamental building block to displaying your data is the feature known as custom formats. Here is the definitive ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More WordTips (ribbon)

Indenting a Table

Insert a table into your document and it normally appears aligned with the left margin. Word allows you to indent the ...

Discover More

Underlining Cells, Not Space Between Cells

Word provides a couple of ways you can underline information, including underlining table cells and their contents. ...

Discover More

Copying Fill Color in a Table

You may spend some time getting the color in a portion of a table just right, only to be faced with the task of copying ...

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}] 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 five less than 7?

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.

Newest Tips
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.