AjapaReporter

Home life · Updated

How to Stretch Rows in Excel: 4 Easy Ways

Time it takes5 min
Steps4in the list below
LevelEasyno special skills
Official sourceMicrosoft Supportcheck it for changes

Quick answer To stretch rows in Excel, select the row(s), then drag the bottom border of the row header down, or use the Format > Row Height option to set a specific height.

What You’ll Need

  • Microsoft Excel (any recent version, desktop or web)
  • A spreadsheet with rows you want to adjust
  • A mouse or trackpad (keyboard shortcuts work too)

Step-by-Step

  1. Select the row(s) – Click the row number on the left side of the sheet to select the entire row. To select multiple rows, click and drag across the row numbers, or hold Ctrl (Windows) or Cmd (Mac) while clicking row numbers.
  2. Drag the row border – Move your cursor to the bottom edge of the row number (the line between two row numbers). The cursor changes to a double-headed arrow. Click and drag downward to increase the row height, then release the mouse button.
  3. Set an exact height (optional) – Right-click the selected row number and choose Row Height. In the dialog box, type a number (in points) and click OK. The default row height is usually 15 points, so anything larger will stretch the row.
  4. Auto-fit to content (optional) – Double-click the bottom border of the row number. Excel will automatically adjust the row height to fit the tallest content in that row. This works best when you have wrapped text or larger fonts.

Common Mistakes

  • Dragging the wrong border – Dragging the top border of a row resizes the row above it, not the selected row. Always use the bottom border of the row you want to stretch.
  • Selecting cells instead of rows – If you select cells (not entire rows), dragging the border will only affect those cells’ row height, which can lead to uneven rows.
  • Using the column border – The column border (between column letters) changes column width, not row height. Make sure you’re on the row number area.
  • Not considering merged cells – Auto-fit may not work correctly if the row contains merged cells. You’ll need to set the height manually in that case.

Tips

  • To stretch all rows at once, select all cells by clicking the triangle at the top-left corner (where row and column headers meet), then drag any row border.
  • Use the keyboard shortcut Alt + H + O + H (Windows) to open the Row Height dialog quickly.
  • If you want rows to automatically adjust as you type, leave them at default height and use Wrap Text (Home > Wrap Text) – Excel will auto-fit when you double-click the border.
  • For a uniform look, set the same row height for multiple rows by selecting them first, then using the Row Height dialog.

Troubleshooting

Row height won’t change

Check if the worksheet is protected. Go to Review > Unprotect Sheet (you may need a password). Also, make sure the row is not part of a group that is collapsed – expand the group first.

Auto-fit doesn’t work

If double-clicking the border doesn’t adjust the height, the row may contain merged cells or an object (like a chart or image) that Excel can’t auto-fit. Set the height manually instead.

Rows are too tall after auto-fit

Sometimes auto-fit creates extra space. Undo with Ctrl + Z (or Cmd + Z), then manually set a smaller height using the Row Height dialog.

Dragging affects multiple rows

If you’ve selected multiple rows, dragging one border will resize all selected rows to the same height. To resize individually, click a single row number first.

Frequently Asked Questions

How do I stretch all rows to the same height?

Select all rows (click the triangle at the top-left), then right-click any row number and choose Row Height. Enter the desired height and all rows will match.

Can I stretch rows using the keyboard?

Yes. Select the row(s), press Alt + H + O + H (Windows) or Cmd + Option + H + O + H (Mac), type the height, and press Enter.

What is the default row height in Excel?

It varies by font and zoom level, but typically it’s 15 points (about 20 pixels). You can change it globally by selecting all rows and setting a new height.

Why does my row height reset when I close the file?

This can happen if the row height is set to ‘Auto’ and the content changes. To lock the height, set a specific number in the Row Height dialog instead of relying on auto-fit.

How do I stretch rows in Excel Online (web version)?

The same drag method works. Right-click a row number and choose Row Height, or double-click the border to auto-fit. The interface may look slightly different but the functionality is the same.

Sources: Microsoft Support. Menus and buttons can differ slightly by version. Spotted something out of date? Tell us.