See all How-To Articles

Make All Rows / Columns the Same Size in Excel & Google Sheets

In this tutorial, you will learn how to make all rows the same height and all columns the same width in Excel and Google Sheets.

 

make all columns same width

 

When working in Excel, we often have data exported from some other system and the general layout can be pretty messy. Therefore we may need to sort out the worksheet to be able to work with data. One thing that often needs to be done is to set all rows to the same height and all columns to the same width.

Make All Rows the Same Height

To make all rows the same height, follow these steps:

1. Select all cells in the worksheet. To do this, click on the arrow in the upper left corner of the gridlines.

 

select all cells

 

2. In the Ribbon, go to Home > Format > Row Height.

 

set row height 1

 

3. In the pop-up screen, (1) set Row height (for example, we set 20 here), and (2) click OK

 

set row height 2a

 

As a result, all cells in the worksheet now have the same height (20).

 

all rows same height

 

Make All Columns the Same Width

Similarly, we can make all columns the same width by following these steps:

1. Select all cells in the worksheet. To do this, click on the arrow in the upper left corner of the gridlines.

 

select all cells

 

2. In the Ribbon, go to Home > Format > Column Width.

 

set column width 1

 

3. In the pop-up screen, (1) set Column width (for example, we set 15 here), and (2) click OK.

 

set column width 2a

 

As a result, all cells in the worksheet now have the same height (15). Now the whole worksheet has cells with the same height and width.

 

all cells same height width

 

Make All Rows the Same Height by Dragging

Another way to make all rows the same height is to drag a row boundary while all rows are selected.

1. Select all cells in the worksheet. To do this, click on the arrow in the upper left corner of the gridlines.

 

select all cells

 

2. Now, click on the line between any two rows’ numbers and drag the cursor up or down to resize a row. This resizing will actually resize all the rows in the worksheet. While we’re dragging the cursor, we’ll see row heights in points and pixels, so we can set an exact value if we want.

 

same height rows dragging 1

 

As you can see in the picture below, we set the same row height for all rows in the sheet.

 

all rows same height

 

Make All Columns the Same Width by Dragging

Just like sizing rows, as shown above, we can also make all columns the same width by dragging the cursor right or left.

1. Select all cells in the worksheet. To do this, click on the arrow in the upper left corner of the gridlines.

 

select all cells

 

2. Now, click on the line between any column letter and drag the cursor left or right in order to resize a column. As we saw previously, this resizing will affect all the columns in the worksheet. While we’re dragging the cursor, we’ll see columns width in points and pixels, so we can set an exact value if we want.

 

same width columns dragging 1

 

Again, we achieved the same result and made all the columns the same width.

 

all cells same height width

 

Note that macros can also be used to change row height and column width.

Make All Rows the Same Height in Google Sheets

To make all rows the same height in Google Sheets, do the following:

1. First, select Row 1 by clicking on its header and press CTRL + SHIFT + DOWN to select all visible rows.

2. Next, (1) click on any row heading (numbers) and (2) press Resize rows 1-1000.

 

resize rows google sheets

 

3. In the pop-up screen, (1) select Specify row height and (2) set row height, for example, 25. (3) Click OK.

 

resize rows google sheets 2

 

As a result, all cells have the same height (25).

 

all rows same height google sheets

 

Make All Columns the Same Width in Google Sheets

Now we can also make all columns the same width in Google Sheets.

1. First, select Column A by clicking on its header and press CTRL + SHIFT + RIGHT in order to select all visible columns.

2. Next, (1) click on any column heading (letter) and (2) press Resize columns A-Z.

 

resize columns google sheets

 

3. In the pop-up screen, (1) select Enter new column width in pixels and (2) set column width, for example, 50. (3) Click OK.

 

resize columns google sheets 2

 

Finally, all cells in this sheet have the same height and width.

 

all cells same height width google sheets

 

We can also resize all rows or columns in Google Sheets by dragging. This works exactly the same as shown above for Excel.