In Excel 2007

Highlight your range of cells
Go to the HOME Tab of the Ribbon.
Then the "Cells" section.
Click on the "Format" dropdown
Select "Autofit Column Width".

HTH
Elkar


"Jeff" wrote:

In Excel 2003, you could highlight a range of cells in a column (say,
A20.A28), right-click, and choose the option to adjust the column width to
best-fit these cells. Has this functionality been dropped from 2007? I
don't want to double-click the A/B column divider, because this wouldn't set
the column width based on just the cells A20.A28. Thanks.