| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select Range based on column name and not A1 notations | Excel Discussion (Misc queries) | |||
| Sort a range of data based on another column | Excel Discussion (Misc queries) | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| I want to use sumif to sum up a column based on a range of dates | Excel Worksheet Functions | |||
| EXCEL Sum column based on time range in different column? | Excel Worksheet Functions | |||
Threaded Mode
