Best-fit column based on a cell range
 

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.

Best-fit column based on a cell range
 

Excel 2003 does not have that function on the right-click menu.

Maybe you used VBA code to add a Command and assign a macro to that on the
r-click(Cell) Command Bar?

You have to select the range then FormatColumnAutofit Selection.

I'll bet 2007 has the same function.


Gord Dibben MS Excel MVP

On Fri, 9 Jan 2009 12:12:23 -0800, 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.

Best-fit column based on a cell range
 

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.