What is the default row height of ms Excel

See all How-To ArticlesResize Cells to Default Row Height in Excel & Google SheetsIn this article, you will learn how to resize cells to default row height in Excel and Google

What is the default row height of ms Excel

See all How-To Articles

Resize Cells to Default Row Height in Excel & Google Sheets

In this article, you will learn how to resize cells to default row height in Excel and Google Sheets.

resize row height excel

In Excel, the default row height is 15 (20 pixels), and the column width is 8.43 (64 pixels). Well explain how to resize cells to default row height and column width.

Resize Cells to Default Row Height  Format Cells Option

Our data set has rows with different heights.

resize row height initial data

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

1. Select all rows that you want to resize (29), and in the Ribbon, go to Home > Format > Row Height

resize row height format 1

2. In the pop-up window set Row height to 15.

resize row height-initial data 2

As a result, all rows now have the default height of 15.

resize row height initial data 3

Resize Cells to Default Column Width by Dragging

Another way to resize rows or columns is to drag and drop columns or rows headings. Now you will display how to resize column width to default by dragging. Our initial data set has different column widths.

resize column width initial data

To resize column width, (1) select all columns in the range (B:G), (2) position a cursor on a line between two column letters until the two-sided arrow appears, then drag it until the width is set to 8.43 and drop.

resize column width drag

Finally, all selected columns width is set to default.

resize column width

Note: You can also resize cells to their default height by using the VBA code.

Resize Cells to Default Row Height in Google Sheets

In Google Sheets, the default row height is 21, and the column width is 100. Our data set has different column widths and row heights.

google sheets initial data

To resize rows to default height, follow these steps:

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., 29).

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

google sheets resize rows

3. In the pop-up screen, select Specify row height, leave the default value (21), and click OK.

google sheets rows set height

As a result, all rows now have the default height of 21.

google sheets row height default

Resize Cells to Default Column Width in Google Sheets

As with row height, you can also set the column width to default.

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., BG).

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

google sheets resize columns

3. In the pop-up screen, (1) select Enter new column width in pixels, (2) leave the default value 100, and (3) click OK.

google sheets resize columns set width

Finally, all columns have the default width of 100.

google sheets column default width

Video liên quan