Warning: Invalid argument supplied for foreach() in /home/techrecipes/public_html/wp-content/themes/techrecipes/header.php on line 77

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.

  • http://piyushsoni.com/ Piyush Soni

    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

      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

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

  • Rita

    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!

  • Ari Widianto

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

  • Lup

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

  • rob

    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.