Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Shrinking Cell Contents.

Shrinking Cell Contents

by Allen Wyatt
(last updated July 21, 2012)

Excel includes a feature that allows you to shrink the contents of a cell so that everything fits on a single line. This feature can have bizarre results if the cell contains quite a bit of text, or if the column width is relatively narrow. You can take advantage of this feature by following these steps:

  1. Choose the cell (or cells) you want to affect.
  2. Choose Cells from the Format menu. Excel displays the Format Cells dialog box.
  3. Make sure the Alignment tab is selected. (See Figure 1.)
  4. Figure 1. The Alignment tab of the Format Cells dialog box.

  5. Make sure the Shrink To Fit check box is selected.
  6. Click on OK.

You should note that this option does not cause Excel to reduce the point size of the text within the cell, only to make it appear to be smaller. This may sound confusing, and quite frankly is of little consequence when applied to the real world. Whether the point size is technically adjusted or not, the information in the cell still appears smaller, as necessary, to fit everything on a single line.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2764) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Shrinking Cell Contents.

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

Unwanted Numbering on Pasted Tables

When pasting text from another document or from the Web you can have unexpected characters sometimes show up. Many of them ...

Discover More

Printing Only Selected Pages

When you print a worksheet, you don't need to print the whole thing. You can print only the pages you want. Here's how to do ...

Discover More

Hiding Errors on Printouts

If there are error values in a worksheet, you may not want those error values to appear on a printout. Excel actually allows ...

Discover More

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

MORE EXCELTIPS (MENU)

Exporting Latitude and Longitude

A handy way to store latitude and longitude values in Excel is to treat them as regular time values. When it comes around to ...

Discover More

Changing the Default Font

If you don't like the font that Excel uses, by default, in a workbook, you can change it. Here's how.

Discover More

Adjusting Cell Margins for More White Space

Is the information in your cells too jammed up? Here are some ways you can add some white space around that information so it ...

Discover More
Subscribe

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

View most recent newsletter.

Comments for this tip:

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. 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 seven minus 6?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, 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.

Links and Sharing
Share