Best-fit column based on a cell range

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

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.
 
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 Format>Column>Autofit Selection.

I'll bet 2007 has the same function.


Gord Dibben MS Excel MVP
 
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
 
Back
Top