You can change row height in Google Sheets by dragging the row boundary, double-clicking to autofit, or setting an exact pixel height from the row menu. Pick the method that matches whether you need one tidy row or a consistent layout across a report.

Why finance teams care (briefly)

Readable rows matter when you present a P&L, budget vs actuals, or dashboard tabs to leadership. Autofit keeps wrapped account names visible; fixed heights keep printed board packs aligned. The formatting tip below is small. The bigger win is feeding those rows with live books data instead of stale exports. That is where LiveFlow for Google Sheets fits.

How to adjust row height in Google Sheets

Using the mouse (one row)

1. Place the cursor between the row index you want to resize and the row index below it.

2. When the ↕ resize cursor appears, click and drag until the cell content is fully visible, then release.

3. The row height updates.

Best for a single adjustment. For many rows, use autofit or the menu methods below.

Autofit with a double-click (multiple rows)

1. Select the row indexes you want to adjust.

2. Place the cursor between two adjacent indexes in that selection.

3. When the ↕ mark appears, double-click it.

4. Sheets autofits each selected row to its content.

Note: autofit can produce uneven row heights when some cells hold more text than others. That is expected.

Using Resize rows → Fit to data

1. Select the row indexes to adjust.

2. Right-click the selection.

3. Choose Resize rows X-Y (Sheets labels the range, for example “Resize rows 2-6”).

4. Select Fit to data.

5. Confirm. Selected rows expand or shrink to show values fully.

Using Resize rows → Specify row height

1. Select the row indexes to adjust.

2. Right-click the selection.

3. Choose Resize rows X-Y.

4. Select Specify row height and enter a pixel value.

5. Click OK.

Use a fixed height when you want uniform spacing across a report table.

How do you autofit column width in Google Sheets?

Column width follows a similar pattern (drag, double-click autofit, or a resize menu). Pair consistent column widths with intentional row heights so printed and on-screen reports stay aligned.

Is there another way to show a long value in a cell?

Yes. Wrap text keeps the column width fixed while letting content use more vertical space. Autofitting row height after wrapping usually makes long account names readable without stretching the whole sheet.

Why finance teams use LiveFlow

Once the sheet looks right, the next bottleneck is usually the data: re-exporting QuickBooks, pasting actuals, and fixing broken links every close. LiveFlow FP&A pulls live accounting data into Google Sheets so your formatted reports stay current without rebuilding the layout each month.

CTA: Book a demo of LiveFlow FP&A for Google Sheets.