Auto-fit Column Width

 

The Format_Column_Auto-Fit Width menu function sets the width of the worksheet columns that you select to the width of their widest element (excluding the header).