How to edit row size in Google Sheets
Learn how to resize rows in Google Sheets by dragging, entering exact pixel heights, or auto-fitting rows to match your content.
Quick answer
To edit row size in Google Sheets, right-click a row number and select Resize row, then enter a pixel height or choose Fit to data. You can also drag a row's bottom border with your mouse, or double-click that border to auto-fit the row to its tallest cell content.
Steps at a glance
- Click the row number to select the row
- Right-click and choose Resize row from the menu
- Enter a specific height in pixels, or select Fit to data
- Alternatively, drag the row's bottom border up or down
- Double-click the border to auto-fit height to content
- Select multiple row numbers first to resize them together
Summary
Row height in Google Sheets defaults to 21 pixels, which only fits a single line of text. Adjusting row size lets you display wrapped text, larger fonts, or images clearly, and you can set it manually, type an exact pixel value, or let Sheets auto-fit rows to their content.
Step-by-step guide
Step 1
Select the row or rows you want to resize
Click the numbered row header on the left side of the sheet to select a single row. To resize several rows at once, click the first row number, then hold Shift and click the last row number in the range, or hold Ctrl (Cmd on Mac) to select non-adjacent rows.
Step 2
Open the Resize row dialog
Right-click any selected row number and choose Resize row from the context menu. A dialog box appears with two options: entering a custom height in pixels or selecting Fit to data, which automatically sets the row to match its tallest cell content.
Step 3
Enter an exact pixel height
In the Resize row dialog, type the exact height you want in the input field, then click OK. This is useful when you want consistent row sizing across a table, especially if you're combining it with features like /guides/google-sheets/wrap-text to display multi-line entries neatly.
Step 4
Drag the row border to resize manually
Hover your cursor over the bottom edge of a row number until it turns into a double-arrow icon, then click and drag up or down to shrink or expand the row. Release the mouse button once the row reaches the height you want.
Step 5
Double-click to auto-fit the row instantly
Position your cursor on the bottom border of a row number and double-click. Google Sheets automatically expands or shrinks the row to fit its tallest piece of content, which is the fastest way to fix a row that's cutting off text.
Step 6
Apply the same height across multiple rows
Select all the rows you want to match, right-click, and choose Resize row, then enter one pixel value that applies to every selected row at once. This keeps tables looking uniform, particularly helpful if you're preparing data for a /guides/google-sheets/create-a-pivot-table or sharing the sheet with a team.
Why this matters
You need this when a row full of wrapped text, notes, or comments gets cut off and looks cramped. Resizing rows properly makes multi-line entries readable, keeps your sheet looking organized, and prevents important data from being hidden behind a row that's too short to display it.
Frequently asked questions
What is the default row height in Google Sheets?
The default row height is 21 pixels, which comfortably fits a single line of standard-sized text but not wrapped text, images, or larger fonts.
Can I resize columns the same way I resize rows?
Yes. Every method for resizing rows, including dragging, the Resize dialog, and double-click auto-fit, works identically for columns. Just select the column letter instead of the row number.
Does resizing a row affect the data inside it?
No, resizing only changes the visual height of the row. Cell values, formulas, and formatting remain unchanged regardless of how tall or short you make the row.
Create interactive demos like this one — free, no coding required.
Start for free →