The fastest way to change cell height in Excel

Cell height in Excel is controlled by row height—the measurement of how tall an entire row is. To change it, click the row number on the left side of the spreadsheet to select the whole row, then right-click and choose "Row Height" from the menu. Type the number you want (measured in points, where 15 points is the default) and click OK.

If you want the row to fit your content automatically instead of setting a fixed height, select the row and double-click the border between that row number and the next one. Excel will expand the row just enough to show all the text inside.

You can also select multiple rows at once by clicking the first row number, holding Shift, and clicking the last row number you want to change. Then right-click and adjust the height for all of them together.

Key Takeaways

  • Row height is set by clicking the row number, right-clicking, and choosing "Row Height" to enter a specific measurement in points.
  • Double-clicking the border between two row numbers auto-fits the height to whatever content is in that row.
  • You can change multiple rows at once by selecting them together before adjusting the height.
  • The default row height is 15 points; most text fits in 20 to 30 points depending on font size.
  • Wrapped text inside a cell may need more row height than a single line of text.

Using the Format menu instead of right-click

If right-clicking does not work or you prefer using the menu bar, you can reach row height through the Format menu. Select the row or rows you want to change, then click Format in the top menu, hover over "Row," and click "Height."

This method works the same way as right-clicking—you enter a number in points and click OK. Some people find it easier to use when they are working with a touchpad or when right-click is not responding as expected.

Auto-fitting rows when text wraps across multiple lines

When you turn on text wrapping inside a cell, the text breaks into multiple lines within that single cell. The row height does not automatically expand to show all the wrapped text, so you have to adjust it manually or use auto-fit.

To auto-fit after wrapping text, select the row and double-click the border between that row number and the next. Excel measures the tallest cell in that row and expands the row height to fit it. This is faster than guessing a height number.

If auto-fit does not expand the row enough, you can manually increase it by right-clicking the row number, choosing "Row Height," and entering a larger number. Try 30 or 40 points as a starting point for wrapped text, then adjust up or down based on what you see.

Setting a specific height for multiple rows at once

To change the height of several rows to the same measurement, click the first row number, then hold Shift and click the last row number in the range you want. All rows between them will be highlighted in blue.

Right-click anywhere on the selected rows and choose "Row Height." Enter the number you want, and Excel will set all selected rows to that exact height. This is useful when you are formatting a table and want consistent spacing throughout.

If some rows need different heights, you can select them individually by holding Ctrl and clicking each row number separately. Then right-click and set them all to the same height at once.

Understanding row height measurements

Excel measures row height in points, not inches or centimeters. One point equals 1/72 of an inch. The default row height is 15 points, which fits most standard text at normal font sizes.

If you increase font size inside a cell, you may need to increase row height too. A cell with 14-point font usually needs 18 to 20 points of row height. A cell with 18-point font might need 25 to 30 points. The exact number depends on the font you are using and whether the text wraps.

You can see the current height of a row by clicking the row number and looking at the row height value that appears when you right-click. This helps you match heights across different parts of your spreadsheet.

Resizing by dragging the row border

You can also change row height by dragging instead of using menus. Move your cursor to the border between two row numbers on the left side of the spreadsheet until the cursor changes to a resize arrow (it looks like a line with arrows pointing up and down).

Click and drag that border up to make the row shorter or down to make it taller. Release the mouse when the row is the height you want. This method is quick if you only need to adjust one or two rows and you can see the result immediately.

Dragging works for multiple rows too. Select the rows first, then drag the border of any selected row. All selected rows will resize together by the same amount.

Frequently Asked Questions

What is the difference between row height and column width?

Row height controls how tall a row is (vertical spacing), while column width controls how wide a column is (horizontal spacing). You change row height by clicking row numbers on the left; you change column width by clicking column letters at the top. Both are measured differently—row height in points, column width in character units.

Can I set a minimum row height so text does not get cut off?

Excel does not have a minimum height setting, but you can use auto-fit to expand rows based on content, or you can manually set a height that works for your data. If you want all rows to have the same minimum height, select all rows, right-click, and set a height that leaves room for your largest font size.

Why does my row height keep changing when I edit text?

If you have auto-fit turned on or if you are using wrapped text, Excel may adjust row height when you add or remove text. To prevent this, set a fixed row height by right-clicking the row, choosing "Row Height," and entering a specific number. The row will then stay that height no matter what you type.

How do I make all rows the same height at once?

Click the select-all button (the small 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." Enter the height you want, and every row in the sheet will be set to that measurement.

What if I accidentally made a row too tall and want to undo it?

Press Ctrl+Z (or Cmd+Z on Mac) to undo the last change. If you have already made other changes since then, you can select the row, right-click, and choose "Row Height" to manually set it back to 15 points, which is the default.