Auto-adjust column width

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
 
F

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
 
J

Jack Schitt

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column width format 2
modifying cell width within same column, but on different rows 2
GridView Column Width Nightmares!!!!! 1
Autosize the column width 5
TextBox with Fixed Width and Autosized Height 4
How can I adjust column width of a single cell within Excel 2003? 2
Use VBA to auto-adjust column widths of subform 0
Vary column width and row height in the same worksheet 1

Top