How to Make All Columns the Same Width in Excel 2013

Having very wide or very skinny columns in Excel can make it difficult to work with the rest of the data in your spreadsheet. Whether those column widths were changed intentionally or by accident, it is helpful to be able to resize a column by clicking on its border and manually dragging the column until it is the right size.

But changing the size of each column in a spreadsheet can be tedious, so you may be looking for a faster way to change the width of multiple columns. Our guide below will show you how to select your entire spreadsheet and simultaneously change the column width of every column that you have selected.

Change the Width of Multiple Columns in Excel 2013

The steps in this article are going to show you a quick way to select all of the columns in your spreadsheet, then apply the same column width to all of those columns. Note that, depending upon the amount of data that is in your cells, this may cause some data to be hidden. Note that you can use a similar method to change the height of multiple rows instead.

Step 1: Open your spreadsheet in Excel 2013.

 

Step 2: Click the cell above the row 1 heading, and to the left of the column A heading. This select the entire spreadsheet. If you only want to change the width of some of your columns, then you can manually select them by holding down the Ctrl key on your keyboard as you click each column letter.

select the whole spreadsheet

 

 

Step 3: Right-click on any selected column letter, then choose the Column Width option.

change width of multiple columns in excel

 

 

Step 4: Enter your desired column width into this field, then click the OK button. The default column width is 8.43, but you can use any value that you would like.

how to make all columns the same width in excel 2013

 

 

Are you having trouble getting your spreadsheet to print properly? Check out our Excel print guide for some tips and tricks that can make printing your data a little easier.