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: Countering Compressed Columns.

Countering Compressed Columns

Written by Allen Wyatt (last updated March 1, 2025)
This tip applies to Excel 97, 2000, 2002, and 2003


Mark is experiencing a problem where, when he opens a workbook, many of the column widths have been compressed (narrowed) and need to be reset. This could be caused by a number of different things, so you'll need to do some checking.

The first thing to check is if someone else is opening the workbook. For instance, if the workbook is accessible across a network, and another person opens it, they could be changing the column widths. The user could even be doing this inadvertently. For instance, if the user has a different screen resolution than yours, then Excel will adapt the workbook to that resolution, and that may change the column widths. The solution is to either make sure that nobody else opens the workbook or make sure that everyone uses the same screen resolution.

You should also check your Zoom setting for the workbook. It could be that the column widths aren't changing at all, but that the Zoom setting is. This would make the columns appear to be a compressed width, even though they aren't.

Finally, it could also be that there are elements in the workbook that are forcing Excel to change column widths when they are automatically calculated. There have been reports of elements such as PivotTables and graphics causing column widths to change automatically.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1980) 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: Countering Compressed Columns.

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

Converting a Text Box to a Frame

These days, most people using Word know what text boxes are but have no idea about frames. Yet, for some purposes, frames ...

Discover More

Saving Documents Faster

If you are using Word versions 97 through 2003, there's a setting you can make that will allow you to save your documents ...

Discover More

Different CSV Formats

Excel provides different CSV formats you can use to export your workbook data for use with other programs. What are those ...

Discover More

Dive Deep into Macros! Make Excel do things you thought were impossible, discover techniques you won't find anywhere else, and create powerful automated reports. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable. You’ll find step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and solutions. Check out Microsoft Excel 2019 VBA and Macros today!

More ExcelTips (menu)

Changing Column Width

When creating a worksheet, you often need to adjust the width of columns so your data looks great. Here's how to quickly ...

Discover More

Understanding Column Widths

Ever wonder why column widths are expressed in characters? The answer is rooted in history, as discussed in this tip.

Discover More

Centering Across Columns

Have a heading you need centered across a few columns? It's easy to do using the tool described in this tip.

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

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 3 + 2?

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


This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

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.