See all How-To Articles

Resize Multiple (or All) Rows / Columns at Once in Excel & Google Sheets

In this tutorial, you will learn how to resize multiple rows or columns at once in Excel and Google Sheets.

 

resize multiple rows columns 2

 

In Excel, you can resize multiple rows or columns at once by right-clicking or using the Format option in the Ribbon.

Resize Multiple Rows at Once by Right-Clicking

1. To change the height of multiple rows at once, (1) first select multiple rows by clicking on a row number and dragging down to the last row you want to resize.
OR hold CTRL and click on the rows number you want to select (e.g., 1–10).

2. After that, (2) right-click anywhere in the selected area and (3) choose Row Height.

 

resize row right click 1

 

3. In the pop-up screen, set the Row height (for example, 15).

 

resize row format height 1

 

As a result, Rows 1–10 now have the same height: 15.

 

resize row right click height 2a

 

Resize Multiple Rows at Once Using the Format Option

You can achieve the same thing using the Format option in the Ribbon.

1. First, (1) select multiple rows by clicking on a row number and dragging down to the last row you want to resize.
OR hold CTRL and click on the rows number you want to select (e.g., 1–10).

2. After that, in the Ribbon, (2) go to the Home tab, (3) choose Format in the Cells group, and (4) click on Row Height.

 

resize row format 1

 

3. In the pop-up screen, set the Row height (for example, 15).

 

resize row format height 1

 

You get the same result as above: Rows 1–10 now have the same height, 15.

 

resize row right click height 2a

 

Resize Multiple Columns at Once by Right-Clicking

1. To change the width of multiple columns at once, (1) first select multiple columns by clicking on a column heading (letter) and dragging across to the last column you want to resize.
OR hold CTRL and click on the column letters that you want to select (e.g., A–G).

2. After that, (2) right-click anywhere in the selected area, and (3) choose Column Width.

 

resize column right click 1a

 

3. In the pop-up screen, set the Column width (for example, 10).

 

resize column right click width 1

 

As a result, Columns A–G now have the same width: 10.

 

resize column right click width 2

 

Resize Multiple Columns at Once Using the Format Option

You can achieve the same thing using the Format option in the Ribbon.

1. First, (1) select multiple columns by clicking on a column heading (letter) and dragging across to the last column you want to resize.
OR hold CTRL and click on the column letter you want to select (e.g., A–G).

2. After that, in the Ribbon, (2) go to the Home tab, (3) choose Format in the Cells group and (4) click on Column Width.

 

resize column format option 1

 

3. In the pop-up screen, set the Column width (for example, 10).

 

resize column right click width 1

 

You get the same result as above: Columns A–G now have the same width (10).

 

resize column right click width 2

 

Resize Multiple Rows at Once in Google Sheets

The only way you can resize multiple rows in Google Sheets is by right-clicking. This is almost the same procedure as in Excel.

1. First, (1) select multiple rows by clicking on a row number and dragging down to the last row you want to resize.
OR hold CTRL and click on the rows number you want to select (e.g., 1–10).

2. After that, (2) right-click anywhere in the selected area, and (3) choose Resize rows 1 – 10.

 

resize rows google sheets 1

 

3. In the pop-up screen, select Specify row height and set the row height (for example, 30).

 

resize rows google sheets height 1

 

As a result, Rows 1–10 now have the same height: 30.

 

resize rows google sheets height 2a

 

Resize Multiple Columns at Once in Google Sheets

Resizing columns in Google Sheets works exactly the same as in Excel.

1. First, (1) select multiple columns by clicking on a column heading (letter) and dragging across to the last column you want to resize.
OR hold CTRL and click on the column letters that you want to select (e.g., A–G).

2. After that, (2) right-click anywhere in the selected area and choose (3) Resize columns A – G.

 

resize columns google sheets

 

3. In the pop-up screen, select Enter new column width in pixels and then set the column width (for example, 60).

 

resize columns google sheets width 2a

 

As a result, Columns A–G now have the same width: 60.

 

resize columns google sheets width 2b