Format, Column, Auto-fit

[wnfisba]

I have a spreadsheet that I have previously saved and cannot seem to
auto-format a column and I don't know why.

Can someone help me here???

Thanks in advance for your help.

wnfisba

 

[Mike]

Perhaps the worksheet is protected, try unprotecting it.

Mike

 

[wnfisba]

It is NOT protected.

Any other ideas....

Perhaps the worksheet is protected, try unprotecting it.

Mike

 

[Gord Dibben]

Do you have any merged cells across a row?

i.e. A1 and B1 are merged.

That column will not autofit.


Gord Dibben MS Excel MVP