Resize Excel column's width automatically

A

Astro J Dog

How can an Excel column's width automatically increase/decrease depending on
the maximium number of digits in any one cell of the column. I am wanting to
use this for a template so the column must be able to increase or decrease. I
am using a version that came with Microsoft Office XP Professional.
 
E

Earl Kiosterud

Dog,

Double click the border in the column header. This is a one-time adjustment
of the column width. It doesn't dynamically adjust the width to the widest
cell as does the Row Height Autofit.
 
Top