Auto-adjust column width

  • Thread starter Thread starter Jack Schitt
  • Start date Start date
J

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
 
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
 
Thanks Frank

Frank Kabel said:
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
Click to expand...
 
Back
Top