Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Hallo dear Superuser members,

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

share|improve this question
1  
Looking at your second screenshot, I think the worksheet is either protected (which you say it isn't) - or maybe it is set as a "Shared Workbook" which multiple users can edit at the same time. If this is the case, see this article –  Peter Albert Feb 26 '13 at 11:19
    
Sharing your workbook will be very much helpful, since for the case there are too many ifs to guess.... –  Peter L. Feb 26 '13 at 18:12

2 Answers 2

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.

share|improve this answer

I would assume the column is locked. Right click on the column and select Format Cells. Then select the Protection tab.

share|improve this answer
    
thank you for your fast answer. I added an other screenshot to my question. The options for adjusting the properties of the columns are greyed out. –  xtarsy Feb 26 '13 at 9:57
    
Do you have ownership of this file, or does some one else administer / distribute it? At our place of work, we used to hide columns or fix widths and prevent other users from gaining access. –  Dave Rook Feb 26 '13 at 10:33

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.