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

The columns in a blank Excel spreadsheet start out the same size, but that can quickly change as you enter data or adjust the layout. So if you have a spreadsheet with different column widths then you might be wondering how to make columns the same size in Excel.

How to Make All Columns the Same Width in Excel

  1. Open your spreadsheet.
  2. Select the columns to resize.
  3. Right-click on a column and choose Column Width.
  4. Type the desired width and click OK.

Our guide continues below with additional information on how to make columns the same size in Excel, including pictures of these steps.

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.

Our tutorial on how to autofit all columns in Excel can provide you with some other options on managing the sizes of your rows and columns.

How to Make Multiple Columns the Same Size in Excel (Guide with Pictures)

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

Now that you know how to make columns the same size in Excel you can start using other options in the program if you want to do things like learn how to expand all rows 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.

Google Sheets also offers many of these same features, if you have been looking for a good, free, online spreadsheet editor.

See also newsletter

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