How to Change Row Size in Google Sheets: A Step-by-Step Guide

Changing row size in Google Sheets is a straightforward process that can be done in a few clicks. This tutorial will show you how to manually adjust row height, use the auto-resize feature, and apply uniform row heights to multiple rows. By the end, you’ll be able to customize the appearance of your spreadsheet, making it more readable and professional.

How to Change Row Size in Google Sheets

In this section, we’ll walk you through the steps needed to change the row size in Google Sheets. Whether you want to adjust a single row or multiple rows, this guide has got you covered.

Step 1: Open Your Google Sheets Document

Open your Google Sheets document by navigating to Google Sheets and selecting your file.

Make sure the spreadsheet you want to edit is open. If it’s not, find it in your drive and open it up.

Step 2: Select the Row(s) You Want to Resize

Click on the number(s) on the left side of the sheet to select the row(s) you want to resize.

You can select multiple rows by holding down the "Shift" key and clicking on additional rows.

Step 3: Right-Click on the Selected Row(s)

Right-click on any of the selected rows to bring up a context menu.

This menu includes several options, but for now, we’re focused on resizing rows.

Step 4: Choose "Resize Row" from the Context Menu

From the context menu, select "Resize row" to open a dialog box.

The dialog box allows you to specify the row height in pixels, giving you precise control.

Step 5: Enter the Desired Row Height

Enter the height you want for the row(s) in the dialog box and click "OK."

You can experiment with different heights to find what looks best for your spreadsheet.

Step 6: Apply Auto-Resize (Optional)

For automatic resizing, double-click the bottom border of the row header.

This feature adjusts the row height to fit the tallest cell’s contents automatically.

After completing these steps, your selected rows will be resized according to your specifications. This change will make the data easier to read and your spreadsheet more visually appealing.

Tips for Changing Row Size in Google Sheets

  • Uniform Height: To apply the same height to multiple rows quickly, select all the rows first and then enter the desired height once.
  • Auto-Resize: Use the double-click method on the row border to auto-resize rows based on content length.
  • Pixel Perfect: If you need exact measurements, use the "Resize row" option and input the height in pixels.
  • Undo Changes: If you’re not happy with the changes, use the "Undo" button (Ctrl+Z) to revert to the previous state.
  • Default Height: The default row height in Google Sheets is 21 pixels; keep this in mind if you need to reset rows to their original size.

Frequently Asked Questions

How do I change the row size for multiple rows at once?

Select all the rows you want to resize, right-click, choose "Resize row," enter the desired height, and click "OK."

Can I auto-resize rows in Google Sheets?

Yes, double-click the bottom border of the row header to auto-resize based on content.

What is the default row height in Google Sheets?

The default row height is 21 pixels.

Can I undo a row height change?

Yes, you can press "Ctrl+Z" or click the "Undo" button to revert the change.

Is there a way to set a minimum row height?

While you can’t set a minimum row height directly, you can manually ensure all rows are at least a certain height by entering the desired pixel value.


  1. Open your Google Sheets document.
  2. Select the row(s) you want to resize.
  3. Right-click on the selected row(s).
  4. Choose "Resize row" from the context menu.
  5. Enter the desired row height.
  6. Apply auto-resize if needed.


Changing row size in Google Sheets is a simple skill that can greatly enhance the readability and presentation of your data. Whether you’re creating a professional report or organizing personal information, knowing how to adjust row height can make your spreadsheet look polished and easy to navigate.

If you’re new to Google Sheets, don’t worry—these steps are easy to follow and will help you quickly become more comfortable with this powerful tool. Plus, with the tips and FAQs provided, you have all the information you need to troubleshoot and customize your Sheets experience.

For further reading, check out other Google Sheets tutorials on formatting, formulas, and data visualization. And don’t forget, practice makes perfect! The more you use Google Sheets, the more intuitive these adjustments will become. Happy spreadsheeting!