Double-Clicking to Widen Columns Won't Work

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.