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

Selecting an Entire Section

Documents can be subdivided into sections, with each of them formatted differently. If you want to select all the text in ...

Discover More

Breaking Links in Lots of Documents

Breaking document links can be a tedious chore, especially if there are lots of links and lots of documents. This tip ...

Discover More

Inserting a Watermark Behind Merged Cells

If you have a group of merged cells into which you want a user to enter information, you may want some sort of ...

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)

Finding an Optimal Table Height

Word can adjust the height of individual rows in a table based on the information you put in each row. This may not ...

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

Self-Adjusting Column Widths

It is important to understand how column widths relate to the margins you may have set in your document. The reason is ...

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 9 - 6?

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.