More excel questions...

[askaboutexcel]

What is one way to let Excel determine the best width of a column?

 

[Derek]

Hi there

You can autofit a column by highlighting that column then moving your curser to the right edge of the column header until it changes from a white cross to a thin black cross. Then doubleclick your left mouse button. You can also autofit several columns by highlighting them all and doing the above on one of the columns.

regards
Derek

 

[tactps]

You can also highlight the whole workbook, then do the double-click if you want to do the whole sheet.