Browse » Home
Wednesday, January 26, 2011
How to Autofit Columns in Excel 2007
Mouse Method
1. Click on the Excel spreadsheet column that you want to autofit by selecting the letter at the top of the column. If you want to select multiple columns, hold the mouse button down and drag the mouse to the last column, then release it. If you need to select nonsequential columns, select the first column, then hold 'Ctrl' and select additional columns.
2. Move your mouse to the right edge of one of the selected columns. Your mouse still has to be above the columns themselves, up where the column letters are. The mouse pointer changes to a line with two arrows coming off of it in opposite directions.
3. Double-click the mouse button to autofit all of the selected columns according to the largest text in the column.
Menu Method
4. Select the cell that you want the column to autofit to.
5. Click on the 'Home' tab at the top of the screen. Locate the 'Cells' area and select the 'Format' button found there.
6. Choose 'AutoFit Selection' from the drop-down box. The width of the entire column changes based on the text in the cell you selected.