Excel: Automatically Sizing Columns To Fit Data
Contributed by Rob Rogers 
Tagged: Microsoft Excel 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.
You may also like -
Java: Multi-Column JList (swing)
Excel 2007: Clear All Formatting From a Range of Cells
Excel 2007: Have Your Data Read Back To You
How To Copy Excel Column Widths
Excel 2007: Use Data Bars for Cell Value Analysis
Excel 2007: Set the Default Column Width for a Worksheet
Excel: Prevent Conversion of URLs into Hyperlinks
Excel 2007: How to View Twitter Updates (Tweets) in a Worksheet
Piyush Soni said on September 22, 2009
This is so painful to take your mouse at that thin column end. Do you know any keyboard short cut for this? I’m searching that for ages :)
Thanks!
Papogi said on April 21, 2011
Record a macro (and assign a keyboard shortcut to run the macro) of you highlighting the entire spreadsheet, then double-clicking on the right edge of the first column, thereby sizing the entire spreadsheet.
ns said on September 9, 2011
I have thousands of columns and this is not an acceptable way.