Excel: Automatically Sizing Columns To Fit Data

Home -> Windows -> Office -> Excel

From the computer of: shamanstears (722 recipes)
Created: Oct 06, 2006     Updated: Oct 18, 2006

Add to:

Excel can automatically size the column or columns selected, based on their longest entries. This gives you a quick and easy way to display your data in a worksheet.

To size a single column:

1. Position your mouse pointer on the right edge of the desired column in the column header

2. The pointer will changes to a double-headed arrow, when it does, double-click the mouse.


To size multiple columns:

1. Select the columns by dragging through them in the column header (or by holding down the Ctrl key and clicking the column letters).

2. Position your mouse pointer on the right edge of one of the selected columns.

3. The pointer will change to a double-headed arrow, when it does, double-click the mouse.