How To Make All Cells The Same Size In Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to make all cells the same size in Google Sheets

How To Make All Cells The Same Size In Google Sheets

When working with Google Sheets spreadsheets, it can be important to make sure that all cells are the same size. This can help keep your tables neat and organized and makes it easier for users to read the data.

Luckily, Google Sheets makes it easy to make sure all your cells are the same size.

In this guide, we will give you a few simple tricks you can use to ensure all your cells have the same size.

We will cover how to modify the width of columns and the height of rows individually. We will also explain how to provide a precise width or height for your cells.

How To Apply the Same Cell Dimensions for All Cells In Google Sheets

Here’s how to apply the same cell dimensions for all cells in Google Sheets.

Step 1

First, we’ll try making all columns in a range the same width. Start by selecting the first column in the range.

We can select an entire column by clicking on the column header. In this case, we’ll select the column header labeled ‘A’.

Step 2

Next, hold the Shift key and select the last column in the range.

Step 3

Use your cursor to adjust the size of the first column. You can do this by placing your cursor on the right-most edge of the column until your cursor turns into a two-headed arrow shape.

Modifying the length of a single column will modify the length of all other selected columns.

Step 4

To make all rows the same height, we can perform a similar method. First, select the starting row of the range you want to modify.

In this example, we’ll start by selecting the first row of our spreadsheet.

Step 5

Hold the Shift key and click on the last row of the range you want to modify.

Step 6

Drag the lower-edge of the row header up and down to modify the height of all selected rows.

Step 7

If you want to be more precise, we can use the Resize option found in the right-click context menu.

Once you’ve selected the rows to modify, right-click on the row header selection and click on the Resize rows… option.

Step 8

A pop-up dialog will prompt the user to either specify a specific row height or to fit the height to the data.

Click on OK to proceed.

Summary

This guide should be everything you need to make all cells the same size in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.