The Easiest Way To Resize Rows And Columns In Google Sheets

When creating or working on a new spreadsheet, you’ll notice that the sizes of the cells are always on default. However, depending on the length or size of the data inside each cell, you will eventually have to resize them and make the data look comfortable being contained in it. When resizing, it could actually be any row or any column and could also be multiple of them.


However, discover this feature in Google Slides may be quite difficult to do for some users, and that’s why we had made the perfect guide to particularly help you with that problem! I know, spreadsheets, in general, are just quite complicated but by reading guides and several more articles, I’m sure you can learn almost everything in an instant.

Continue reading to learn more about resizing rows and columns

Manually Resizing A Single Row or Column

Rows and columns, if you aren’t aware yet, can be done one or multiple at a time. We’ll teach you about how to do them both in Google Slides but for this part, let’s focus on discussing resizing single rows and columns.

1. Open the document you want to edit.

The first and most essential step would be to open the document you wish to modify on your device. Always make sure that it’s the right one.

2. Click on the line between the columns or rows, hold and drag to the left or right.

After that, click the line in between two columns or rows to adjust them according to the size you prefer.

Since it’s manually done, you actually won’t know the accurate size of the row or column you’ll be resizing but just take note of this: move the blue line to the right if you want to make the cell bigger, and left to make it smaller.

The actual same thing is what’s done too when resizing rows in your spreadsheet.

3. Release the mouse after achieving your preferred size for the cells.

Now, once you’ve checked and felt like you’ve achieved the perfect size you want for your cells and columns, simply let go of your hold on the mouse to save the changes.

Resizing Multiple Rows and Columns

If your goal is not to resize not only a single, but multiple rows and columns, this is the most efficient process you can apply. Here are the steps you have to follow:

1. Select the rows or columns you wish to resize.

Check your data and simply select the numbers of the rows or letters of the columns you wish to resize. You will know that they’re selected once it looks as if it was highlighted with black fill.

2. Right-click on your mouse and select “Resize rows” or “Resize columns.”

Afterward, just right-click on your mouse and look for the “Resize rows” or “Resize columns” among all the options shown. Immediately click after seeing it.

3. Enter your desired row or column height and save your changes.

A small pop-up window will show on your screen after clicking that option and in that space, you can edit the height of your rows or columns by typing in your desired number. Take note that the default height is 20 so if you wish for it to be bigger than that, then make sure to enter a greater number than 20. After you’ve thought about the number to put, don’t forget to click the “OK” button to save all the changes.

Finishing Thoughts

Typing in the data might be the easiest part of creating a spreadsheet because the hardest part of it lies in data organization. That includes not only categorizing the data into different sheets in a single spreadsheet, adding borders, putting in titles, and resizing cells so as not to make them look cramped and quite overwhelming. When resizing cells, this is one of the things you have to keep in mind, if you want to achieve a perfect-looking Google Slides spreadsheet!