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: Double-Clicking to Widen Columns Won't Work.

Double-Clicking to Widen Columns Won't Work

by Allen Wyatt
(last updated January 30, 2016)

2

Normally, Excel allows you to double-click on the divider bar between column heads in order to widen a column. For instance, if you need to widen column C, all you need to do is move the mouse so it points to the divider between column headers for column C and column D; the mouse pointer changes to a double-headed arrow. When you double-click, column C is widened to accommodate the widest information in its cells.

There are times when double-clicking to widen a column won't work, however. In particular, Excel won't widen a column in this manner if the worksheet is protected. (The obvious solution is to unprotect the worksheet.)

You also cannot double-click to widen if the column is formatted using the Wrap Text attribute. You can use any different method of widening the column, but you cannot double-click.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2583) 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: Double-Clicking to Widen Columns Won't Work.

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

Changing Colors of Spelling and Grammar Underlines

The red and green wavy underlines used in Word can be a boon for proofing a document, but they are of little use if you have ...

Discover More

Changing the Reference in a Named Range

Define a named range today and you may want to change the definition at some future point. It's rather easy to do, as ...

Discover More

Dates with Periods

You may want Excel to format your dates using a pattern it doesn't normally use—such as using periods instead of ...

Discover More

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!

MORE EXCELTIPS (MENU)

Unhiding Columns that are Persistently Hidden

If you were trying to format a worksheet and nothing you did could make the first two columns appear, would you be ...

Discover More

Hiding and Unhiding Columns

Want to hide a column so it doesn't appear in the worksheet? It's easy to do using the formatting capabilities of Excel.

Discover More

Countering Compressed Columns

If you open a workbook and find that the width of some of your columns has been changed, the discovery can be frustrating. ...

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 3 - 0?

2016-11-01 14:33:36

Nancy F

Neither of these situations is my case and I still cannot widen with a double click. Any other ideas?


2016-01-30 10:06:20

Henry Noble

A simpler description of double-clicking the column divider is that it triggers AutoFit Column Width. So, it will shrink or expand a column.


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.

Links and Sharing