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. 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.


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. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.