Excel – Column width option not available in specific worksheets

microsoft excel

I have the following problem. I have a Excel document with several worksheets. In the February worksheet I can adjust the column width option. I get the double-sided arrow between the two letters. But in the other worksheets I can't change the column width.

enter image description here

In all the other worksheets of this Excel file, this option is not available. I can't find the option to enable/disable adjusting the column width.

At the moment it looks like this when I hover my mouse over the place where the double arrow should appear.

enter image description here

** The whole worksheet is not protected.**

Edit:

The option to change the properties of the columns are greyed out. For all columns.

enter image description here

Best Answer

Normally you only see this when the worksheet/workbook is protected. Try it with a macro. For example:

Sub Test()
    Columns("A:C").ColumnWidth = 20
End Sub

When protected then you get a message that it is unable to set the ColumnWidth property.

Related Question