How to Make Columns the Same Size in Excel for Office 365

When you create a new spreadsheet in Microsoft Excel, all of the rows and columns will be the same size by default.

But as you add data to your spreadsheet and make changes to its layout, it’s likely that you will wind up with columns of different sizes.

This can happen because Excel can expand its columns to fit the data within the cells in that column, which can naturally create columns of different sizes.

However, you have the ability to manually resize your columns, and you can even do it to multiple columns at once.

Our guide below will show you how to select multiple columns in Excel and make them the same size.

How to Make Multiple Columns the Same Size in Excel

The steps in this article were performed in the Microsoft Excel for Office 365 version of the application, but will work in other versions of Excel as well.

Step 1: Open your spreadsheet in Excel.

Step 2: Click on the letter above the first column to resize.

select first column to resize

Step 3: Hold down the Ctrl key on your keyboard, then click the column letter for each additional column to resize.

select multiple columns

Step 4: Right-click on one of the selected columns and choose the Column Width option.

right-click on a column letter, then click Column Width

Step 5: Enter the desired width into the field, then click OK.

how to make multiple columns the same width in Excel

Note that you can select all of the columns in a spreadsheet by clicking the gray button to the left of the column A heading and above the row 1 heading.

You can select multiple adjacent columns by clicking the leftmost column you want to select, then holding down the Shift key and clicking the rightmost column. This will select everything between the two columns you clicked.

Excel defines column width as a point value by default, but you can switch to inches by clicking the View tab, then selecting the Page Layout option.

See also

solveyourtech.com newsletter

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