Auto-adjust column width

[Jack Schitt]

Hi all

Is there a way to set a column width so that it auto-adjusts to the widest
entry in the column? And what about the widest numerical entry, excluding
word-wrapped cells containing text?

I realise that I can double-click on the edge of the column header to
achieve most of the desired result passively, but this does not work if the
worksheet is protected.

Thanks

 

[Frank Kabel]

Hi
depending on your Excel version you can allow formating columns in the
protection dialog. (I think starting with Excel 2002). In all other
cases no chance but to remove cell worksheet protection before
adjusting the column width