How to Make All Columns the Same Width in Excel

Updated

Looking to make all columns the same width in Excel? Here’s a quick how-to guide that will show you the steps you need to take.

How to Make All Columns the Same Width in Excel

When you have a spreadsheet with data that spans multiple columns, you may want to make all of the columns the same width so that the information is easier to read. You can make all columns the same width in Excel in a few different ways. In this article, we’ll show you how to do it.

How to Make All Columns the Same Width in Excel

To resize all the columns in an Excel document, change the Column Width value:

  1. Click the arrow at the top left corner of your spreadsheet between Column A and Row 1 to select all your columns at once
  2. Right Click on any column and click on Column Width
  3. Enter in your column width value and hit OK

Your columns will all now be resized. Alternatively, after selecting all of your columns, you can also drag the size of any individual column to have it apply to all columns.

FAQ

How do I make all cells the same width and height in Excel?

To make all cells the same width and height in Excel, select the cells you want to format. Then, go to the Home tab and click on the Format icon. In the Format drop-down menu, select Column Width. In the Column Width box, type in the desired width and click on the OK button. To format the row height, select Row Height in the Format drop-down menu. In the Row Height box, type in the desired height and click on the OK button.

How do I automatically resize a table in Excel?

To automatically resize a table in Excel, simply click and hold the lower right corner of the table and drag it until the table is the desired size.

What is the shortcut to AutoFit a column in Excel?

To AutoFit a column in Excel, select the column(s) you want to AutoFit, then double-click the boundary to the right of the column header(s).

What is the shortcut to make all rows the same size in Excel?

There is no one-size-fits-all answer to this question, as the shortcut to make all rows the same size in Excel will vary depending on the specific version of Excel that you are using. However, some common shortcuts that can be used to achieve this goal include holding down the Ctrl key while dragging the row height adjustment handle or selecting all rows and then double-clicking on the row height adjustment handle.

For more tech guides, see our Tech Section.