Excel shortcuts

10 Quick and Easy Ways to Expand Columns in Excel

If you work with data in Microsoft Excel, you know that columns are an important part of any spreadsheet. By default, columns are 8.43 characters wide, but you can change the width of columns to better fit the data you're working with. Here are 10 quick and easy ways to expand columns in Excel.

1. To change the width of a column to fit the contents of a cell, double-click the right edge of the column header.

2. To change the width of multiple columns, select the columns you want to change, then double-click the right edge of any of the selected columns.

3. To change the width of all columns on a worksheet, click the Select All button, then double-click the right edge of any column.

4. To change the width of a column to a specific value, select the column(s) you want to change, then click the Home tab. In the Cells group, click Format > Column Width. Enter the width you want in the Column Width dialog box, then click OK.

5. To change the width of a column so that it's wide enough to fit the longest entry in the column, select the column(s) you want to change, then click the Home tab. In the Cells group, click Format > AutoFit Column Width.

6. To change the width of multiple columns to fit the longest entry in each column, select the columns you want to change, then click the Home tab. In the Cells group, click Format > AutoFit Column Width.

7. To make all columns the same width, select the columns you want to change, then click the Home tab. In the Cells group, click Format > Column Width. In the Column Width dialog box, enter a value, then click OK.

8. To make all columns the same width, but wider than the default width, select the columns you want to change, then click the Home tab. In the Cells group, click Format > Column Width. In the Column Width dialog box, enter a value that's larger than 8.43, then click OK.

9. To make all columns the same width, but narrower than the default width, select the columns you want to change, then click the Home tab. In the Cells group, click Format > Column Width. In the Column Width dialog box, enter a value that's smaller than 8.43, then click OK.

10. To hide a column, select the column(s) you want to hide, then click the Home tab. In the Cells group, click Format > Hide Columns.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.