The fastest way to change row height

To change the height of a single row, position your cursor on the border between two row numbers on the left side of the spreadsheet. The cursor will turn into a resize arrow (a double-headed line pointing up and down). Click and drag upward to make the row shorter or downward to make it taller. Release the mouse when the row reaches the height you want.

If you want to set an exact height instead of dragging by eye, right-click on the row number and select Row Height from the menu. A dialog box will appear where you can type a specific measurement in inches. Excel measures row height in points (a printer's unit where 72 points equals one inch), so a standard row is about 15 points tall.

To change multiple rows at once, click on the first row number, then hold Shift and click on the last row number you want to resize. All rows in between will be selected. Now drag the border between any two selected row numbers, and all selected rows will resize together to the same height.

Key Takeaways

  • Drag the border between row numbers to resize by sight, or right-click and choose Row Height to enter an exact measurement in points.
  • Select multiple rows by clicking the first row number, holding Shift, and clicking the last row number, then drag any border between them to resize all at once.
  • Double-click the border between two row numbers to auto-fit the height to the tallest content in that row.
  • The Format menu in the ribbon offers Row Height and AutoFit Row Height options if you prefer not to right-click.

Using AutoFit to match content automatically

When you have text or numbers that don't fit in the current row height, you can let Excel calculate the right height for you. Double-click the border between two row numbers on the left side. Excel will measure the tallest content in that row and expand it just enough to show everything without cutting off text.

To auto-fit multiple rows, select them first (click the first row number, hold Shift, click the last one), then double-click any border between the selected rows. All selected rows will resize to fit their content. This is especially useful when you have wrapped text or large font sizes that need more vertical space.

Changing row height through the Format menu

If you prefer using the ribbon at the top instead of right-clicking, you can access row height controls through the Format menu. Select the row or rows you want to change, then click the Format button in the Home tab of the ribbon. A dropdown menu will appear with options including Row Height and AutoFit Row Height.

Click Row Height to open a dialog where you can type an exact measurement. Click AutoFit Row Height to let Excel resize the row to fit the content automatically. This method works the same way as right-clicking but may feel more natural if you already use the ribbon for other formatting tasks.

Setting a standard row height for your entire sheet

If you want all rows in your spreadsheet to be a certain height, select every row first by clicking the select-all button (the small box in the top-left corner where the row numbers and column letters meet). Then right-click on any row number and choose Row Height. Type the height you want, and every row in the sheet will change to that size.

You can also use the Format menu for this: select all rows, click Format in the Home tab, then choose Row Height. This is useful when you are starting a new spreadsheet and want consistent spacing from the beginning, or when you need to standardize the look of an existing sheet.

Common mistakes and how to avoid them

The most common error is clicking on the row number itself instead of the border between row numbers. If you click the number, you will select the entire row instead of resizing it. Make sure your cursor has changed to the resize arrow (the double-headed line) before you drag.

Another mistake is forgetting that row height is measured in points, not inches or centimeters. If you type 1 into the Row Height dialog expecting one inch, you will get a row that is barely visible. Remember that 72 points equals one inch, so a row height of 20 points is roughly a quarter-inch tall. If you are unsure, use AutoFit instead and let Excel do the math.

When resizing multiple rows, make sure you have actually selected all the rows you want to change before dragging. If you only have one row selected and drag, only that row will resize. Always check that the row numbers are highlighted in blue before you start dragging.

Hiding and unhiding rows as an alternative

If you want to make a row take up less visible space without actually deleting it, you can hide it instead. Right-click on the row number and select Hide. The row will disappear from view, but the data stays in the spreadsheet and will reappear if you unhide it later.

To unhide a row, select the rows on either side of the hidden row (for example, if row 5 is hidden, select rows 4 and 6), right-click, and choose Unhide. The hidden row will reappear. This is useful when you have data you want to keep but do not need to see right now, such as backup calculations or reference information.

Frequently Asked Questions

Why does my row height keep resetting when I type in the dialog?

Make sure you are typing only a number, not a number with units like "0.5 in" or "1 cm". Excel expects the measurement in points. If you want to use inches, multiply by 72 (so 0.5 inches would be 36 points). Type just the number and click OK.

Can I set different heights for different rows at the same time?

No, when you select multiple rows and resize them, they all become the same height. To set different heights, change one row at a time, or select groups of rows that should be the same height and resize each group separately.

What is the default row height in Excel?

The standard row height is 15 points, which is about one-fifth of an inch. This can vary slightly depending on your font size and screen settings, but 15 points is the starting point for most new spreadsheets.

Does changing row height affect the data in the cells?

No, changing row height only changes how much space the row takes up on screen and when printed. The actual data in the cells stays the same. You can make a row as tall or short as you want without losing or changing any information.

How do I make all rows fit their content at once?

Select all rows by clicking the select-all button in the top-left corner, then double-click any border between row numbers. Excel will auto-fit every row in the sheet to match its content. You can also use Format > AutoFit Row Height from the ribbon after selecting all rows.