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

In this tutorial, you will discover how to ensure consistent row heights and column widths in both Excel and Google Sheets. When working with messy data that requires organization, it is often necessary to set all rows to the same height and all columns to the same width. Let’s explore the steps to accomplish this in both platforms.

Make All Rows the Same Height

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

1. Select all cells in the worksheet. You can do this by clicking on the arrow in the upper left corner of the gridlines.

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

3. In the pop-up screen, set the desired row height (e.g., 20) and click OK.

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

Make All Columns the Same Width

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

1. Select all cells in the worksheet by clicking on the arrow in the upper left corner of the gridlines.

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

3. In the pop-up screen, set the desired column width (e.g., 15) and click OK.

As a result, all cells in the worksheet will have the same width (15), ensuring a consistent layout.

Make All Rows the Same Height by Dragging

Another approach to achieve consistent row heights is by dragging a row boundary while all rows are selected. Here’s how:

1. Select all cells in the worksheet by clicking on the arrow in the upper left corner of the gridlines.

2. Click on the line between any two rows’ numbers and drag the cursor up or down to resize a row. This action will resize all rows in the worksheet. You can set an exact value by observing the row heights in points and pixels during the dragging process.

As a result, all rows in the sheet will have the same height, providing a neat and consistent appearance.

Make All Columns the Same Width by Dragging

Similar to resizing rows, you can also make all columns the same width by dragging the cursor right or left. Here’s how:

1. Select all cells in the worksheet by clicking on the arrow in the upper left corner of the gridlines.

2. Click on the line between any column letter and drag the cursor left or right to resize a column. This action will affect all columns in the worksheet. Similar to the row resizing process, you can set an exact value by observing the column widths in points and pixels.

By following these steps, you can ensure that all columns in the worksheet have the same width, enhancing the overall visual consistency.

Note that you can also utilize macros 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, follow these steps:

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

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

3. In the pop-up screen, select “Specify row height” and set the desired row height (e.g., 25). Then, click OK.

As a result, all cells in the Google Sheets document will have the same height (25), ensuring a consistent layout.

Make All Columns the Same Width in Google Sheets

To make all columns the same width in Google Sheets, follow these steps:

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

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

3. In the pop-up screen, select “Enter new column width in pixels” and set the desired column width (e.g., 50). Then, click OK.

By following these steps, all cells in the Google Sheets document will have the same height and width, creating a visually balanced layout.

Finally, keep in mind that you can also resize all rows or columns in Google Sheets by dragging, which works similarly to the Excel process described earlier.