How Do I Make Columns Automatically Expand in Excel 2010?

The default cell size in Microsoft Excel 2010 can fit approximately 8.5 characters. When you are working with small numbers and no letters, this sizing is going to be appropriate for most situations.

Unfortunately, not everyone works with data like that, and you may find yourself needing wider columns on a regular basis. This is why it’s so important to know how to expand cells in Excel.

While you can manually expand Excel columns by clicking the column divider line, that can be tedious and imprecise.

As with most other situations that you might encounter in Excel, there is a faster, automated way of formatting the perfect column width for multiple columns at once. It requires the use of the AutoFit Column Width tool, which you can find on the Home tab in Excel 2010.

You can check out our Excel AutoFit column width shortcut article for other options on using this simple tool to resize your rows and columns.

Automatically Expand Columns to Display the Widest Cell Value

The purpose of this tutorial is to show you how to automatically resize multiple columns at once so that they are the appropriate size for the largest value in the column.

If the largest value is smaller than the default, Excel will actually shrink the column to that size.

This method will also work if you only need to automatically resize one column, but you can accomplish the resizing of one column by double-clicking the column divider line to the right of the column heading.

autofit a single excel column

Begin by opening the Excel file that contains the columns you want to automatically resize.

Click the leftmost column heading that you want to resize, then drag your mouse to select all of your desired columns.

select the columns you want to resize

Click the Home tab at the top of the window.

click the home tab

Click the Format drop-down menu in the Cells section of the ribbon at the top of the window, then click the AutoFit Column Width option.

how do i make columns automatically expand in excel 2010

Your selected columns should now be expanded automatically to the width of the widest cell value in each column.

example result

Note that you can also accomplish this result with the use of keyboard shortcuts.

Hold the Alt key, then press H, then O, then I.

Learn more about how to autofit all columns in Excel if you would like to continue using this feature in your spreadsheets.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Leave a Comment