AjapaReporter

Home life · Updated

How to Shrink Row Height in Excel

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

Quick answer To shrink row height in Excel, select the row(s), go to the Home tab, click Format in the Cells group, choose Row Height, and enter a smaller number. This makes rows more compact so more data fits on screen.

What You’ll Need

  • A computer with Microsoft Excel installed (Windows or Mac).
  • The workbook containing the rows you want to adjust.
  • Basic familiarity with selecting cells and rows.

Step-by-Step

  1. Open your workbook – Launch Excel and open the file where you need to shrink row heights.
  2. Select the row(s) – Click the row number on the left edge to select a single row. To select multiple rows, click and drag over the row numbers, or hold Ctrl (Cmd on Mac) while clicking row numbers for non-adjacent rows.
  3. Open the Row Height dialog – Go to the Home tab on the ribbon. In the Cells group, click Format. From the drop-down menu, choose Row Height….
  4. Enter a smaller value – In the Row Height box, type a number lower than the current value (e.g., change from 20 to 12). Click OK. The selected rows will instantly shrink to that height.

Common Mistakes

  • Selecting the wrong area – Clicking a cell instead of the row number selects only that cell, so the Row Height command may be grayed out. Always click the row number.
  • Setting height too small – Entering a value like 2 or 3 can make text unreadable or cause it to be cut off. Use a value that still shows your content.
  • Forgetting to select all rows – If you want to shrink multiple rows, you must select them all at once. Doing it row by row is slower but works.
  • Using AutoFit by mistake – The “AutoFit Row Height” option automatically adjusts to content, which may increase height instead of shrinking it. Use the manual Row Height option instead.

Tips

  • Use a keyboard shortcut – On Windows, press Alt + H, then O, then R to open the Row Height dialog quickly. On Mac, go to the Format menu and choose Row Height.
  • Shrink multiple sheets at once – Group sheets by holding Ctrl (Cmd on Mac) and clicking sheet tabs, then apply the row height change. This applies to all grouped sheets.
  • Set a default row height – To change the default for new rows, go to Home > Format > Default Height. This won’t affect existing rows.
  • Double-click to auto-fit – but carefully – Double-clicking the bottom edge of a row header auto-fits to content, which can shrink rows if the content is small. This is handy but may not give you exact control.
  • Use the mouse drag method – Hover over the bottom border of a row number until the cursor becomes a double arrow, then drag upward. This is intuitive for quick adjustments.

Troubleshooting

  • Row height won’t change – If the Row Height option is grayed out, you may have selected a whole column or a merged cell. Click the row number to select the entire row, then try again. Also ensure the worksheet is not protected (Review > Unprotect Sheet).
  • Text is cut off after shrinking – The row is too small for the content. Either increase the row height slightly, or wrap text (Home > Wrap Text) so the content fits on multiple lines within the row.
  • Row height resets to auto after editing – If you type new content that is taller than the set height, Excel may auto-expand the row. To prevent this, keep the row height manual and avoid entering content that exceeds it, or use a smaller font size.
  • Multiple rows have different heights – When you select multiple rows and enter a value, all selected rows get that exact height. If some rows appear different, they may have been excluded from the selection.

Frequently Asked Questions

Can I shrink row height without affecting other rows?

Yes, select only the rows you want to change. Unselected rows remain untouched.

What is the minimum row height in Excel?

The minimum is 0, but a row with height 0 is hidden. A practical minimum is around 2–3 points, but text will be unreadable. Use at least 10–12 for normal text.

Why does my row height keep changing back?

This usually happens because you have “AutoFit Row Height” enabled or the content is larger than the set height. Set a manual height and avoid entering content that exceeds it.

Can I shrink row height for all rows at once?

Yes, select all rows by clicking the triangle at the top-left corner (where row and column headers meet), then follow the same steps. This applies to every row in the sheet.

Does shrinking row height affect printing?

Yes, it can make rows shorter on the printed page, which may fit more rows per page. Check Print Preview to ensure content is still visible.

Is there a way to shrink row height based on content?

Use AutoFit Row Height (Home > Format > AutoFit Row Height) to automatically adjust to the tallest content. This may increase or decrease height depending on content.

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