Excel: Automatically Size Columns to Fit Data

Excel can automatically size a column or columns which you have 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, use the following steps:

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

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

To size multiple columns, use the following steps:

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.

 

About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

7 Responses to “Excel: Automatically Size Columns to Fit Data”

  1. September 22, 2009 at 4:00 pm, Piyush Soni said:

    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!

    Reply

    • April 21, 2011 at 12:17 pm, Papogi said:

      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.

      Reply

  2. September 09, 2011 at 1:39 pm, ns said:

    I have thousands of columns and this is not an acceptable way.

    Reply

  3. May 16, 2012 at 3:58 pm, Rita said:

    say I have 4 columns that are both set 2.5 for their width. If I put 2.5 in that column it then shows as 3 because it rounds it up. then again on the next row I put 5.2 it rounds it to 5 . Now the total of that column is 8 but in reality it is 7.7 because the column won’t widen automatically. What do I need to do. I can’t make all the columns larger because I need to save room on the sheet.

    Help!
    Thanks!

    Reply

  4. June 13, 2012 at 7:03 am, Ari Widianto said:

    It’s very helpful. Thank you very much for your nice information. :-)

    Reply

  5. July 20, 2012 at 2:22 am, Lup said:

    When I click on column line no numbers show for size…what could this problem be???

    Reply

  6. November 20, 2012 at 7:26 am, rob said:

    works like a charm!!! thanks, this is exactly what i was looking for. i knew there was a shortcut instead of going to the format menu.

    Reply

Leave a Reply