The Three Ways to Adjust Row Height

You can change row height in Excel by dragging the border between row numbers, by double-clicking to auto-fit, or by typing a specific measurement into the row height dialog. The fastest method depends on whether you want to resize one row, multiple rows, or fit content automatically.

All three methods work the same way in Excel for Windows and Excel for Mac, though the keyboard shortcuts differ slightly. You'll find the row numbers on the left side of your spreadsheet — that's where you'll click and drag or right-click to access height options.

Key Takeaways

  • Drag the border between two row numbers up or down to resize the row above it, and release when the height looks right.
  • Double-click the border between row numbers to auto-fit the row height to whatever content is inside it.
  • Right-click a row number and select "Row Height" to type in an exact measurement in inches or centimeters.
  • Select multiple rows by clicking the first row number, holding Shift, and clicking the last row number, then resize all of them at once.
  • If you make a row too small and can't see the content, select the row and double-click the border to auto-fit it back to normal.

Dragging the Row Border to Resize

Position your cursor on the line between two row numbers on the left side of the spreadsheet. Your cursor will change to a resize arrow (a double-headed arrow pointing up and down). Click and hold, then drag upward to make the row above smaller or downward to make it taller. Release the mouse when the row height matches what you need.

This method works when ready and gives you visual feedback as you drag. It's the fastest way if you're resizing just one or two rows and you don't need an exact measurement. Be careful not to click on the row number itself — you need to click directly on the thin border line between the numbers.

Auto-Fitting Row Height to Content

Double-click the border between two row numbers, and Excel will automatically adjust the upper row's height to fit all the text inside it. This is useful when you've typed a long entry and the row is cutting off part of the text, or when you've pasted content from another source and the heights don't match your data.

Auto-fit works on a single row at a time when you double-click the border. If you want to auto-fit multiple rows at once, select all the rows you want to resize (click the first row number, hold Shift, and click the last row number), then double-click any border between the selected rows. Excel will adjust each row to fit its own content.

Setting an Exact Row Height with the Dialog Box

Right-click on the row number you want to resize. A menu will appear with several options. Click "Row Height" (not "Optimal Height" — that's auto-fit). A small dialog box will open with a text field showing the current height.

Type the new height measurement. Excel measures row height in points by default (72 points equals one inch), but you can type a number followed by "in" for inches or "cm" for centimeters — for example, "0.5 in" or "1.5 cm". Click OK, and Excel will set the row to that exact height. This method is best when you need consistent heights across multiple rows or when you're matching a specific layout requirement.

Resizing Multiple Rows at Once

Click the first row number you want to resize. Hold down the Shift key and click the last row number in the range. All rows between them will highlight in blue. Now you can drag the border between any of the selected rows, and all selected rows will resize to the same height.

Alternatively, right-click any of the selected row numbers and choose "Row Height" to set all of them to an exact measurement at once. This saves time when you're formatting a table or report and need uniform row heights across multiple sections.

Undoing a Row Height Change

If you resize a row and then realize it was a mistake, press Ctrl+Z (Windows) or Command+Z (Mac) to undo the change. Excel will restore the row to its previous height. You can undo multiple changes by pressing the shortcut several times.

If you've closed the file and reopened it, undo won't work — the change is permanent. To reset all rows to Excel's default height, select all rows (click the box in the top-left corner where the row numbers and column letters meet), then right-click and choose "Row Height" and type 15 (the default) or use "Optimal Height" to auto-fit everything at once.

Common Mistakes to Avoid

The most common mistake is clicking on the row number itself instead of the border between row numbers. If you click the number, you'll select the entire row instead of resizing it. The resize cursor only appears when you're directly on the thin line between two numbers.

Another mistake is making a row so small that the content disappears. If this happens, select the row and double-click the border to auto-fit it, or right-click and set the height to a larger number. You won't lose the data — it's just hidden because the row is too narrow to display it.

Don't confuse "Row Height" with "Optimal Height" in the right-click menu. "Optimal Height" auto-fits the row to its content, while "Row Height" opens a dialog where you type an exact measurement. Using the wrong option won't break anything, but it might not give you the result you expected.

Frequently Asked Questions

Can I make all rows the same height at once?

Yes. Click the box in the top-left corner (where row numbers and column letters meet) to select the entire spreadsheet, then right-click any row number and choose "Row Height." Type the height you want, and all rows will resize to that measurement. You can also select just the rows you want to match by clicking the first row number, holding Shift, and clicking the last one.

What's the difference between row height and optimal height?

"Optimal Height" (also called "Auto-Fit") measures the content in each row and adjusts the height to fit it perfectly. "Row Height" lets you type an exact measurement. Use Optimal Height when you want Excel to decide, and Row Height when you need a specific size.

Why can't I see the resize cursor between row numbers?

You're probably clicking slightly to the left or right of the border line. Move your cursor directly onto the thin line between the two row numbers — the cursor should change to a double-headed arrow. If it doesn't, move a few pixels left or right until it appears.

If I make a row very small, does the data get deleted?

No. The data stays in the cell — it's just hidden because the row is too short to display it. Select the row and double-click the border between row numbers to auto-fit it, or right-click and set a larger height. The content will reappear.

Does changing row height affect the data in the cells?

No. Row height only changes how much vertical space the row takes up on the screen and when you print. The actual data in the cells stays exactly the same. You can resize rows as many times as you want without affecting your data.