How to Disable Autofit Row Height in Excel Manually

How-to basics · Updated November 20, 2026

To keep Excel row heights from changing, select the rows, turn off Wrap Text if you need a reliably fixed height, then choose Home > Format > Row Height and enter a value. Excel does not have a permanent switch that disables every AutoFit action; this guide explains how to set and preserve a manual height in Microsoft 365 for Windows, and what to check if rows still change or text gets cut off.

What You’ll Need

  • An Excel workbook you can edit. If it contains important data, save a separate copy before making broad layout changes.
  • The worksheet and rows you want to keep at a consistent height. You can select one row, several rows, or all rows on the sheet.
  • A target height in points. If you are unsure, start with 18 or 20 points, then adjust after checking the text and font you use.

Step-by-Step

  1. Identify what is changing the height. Click a cell in a row that changes. Look for Wrap Text on the Home tab, and note whether the row changes after you edit a cell, paste content, or run AutoFit. These causes are different: AutoFit is a command that sizes a row to its contents, while wrapped text can make a row need more vertical space. Deciding which behavior you want to stop will help you avoid hiding information by mistake.
  2. Select the target rows. To select one row, click its number along the left edge of the worksheet. For adjacent rows, drag across their row numbers or click the first number and Shift-click the last. For separate rows, hold Ctrl on Windows while clicking each row number. To set a height for the whole sheet, click the Select All button at the top-left corner of the grid, above row 1 and left of column A. Check that the intended rows are highlighted before continuing; changing the height of an entire sheet is easy to do accidentally.
  3. Turn off Wrap Text if the height must stay fixed. With the rows selected, choose Home > Alignment > Wrap Text to switch it off if the button is active. With wrapping off, a long entry will not create additional lines within the cell. Its text may extend into neighboring blank cells, or appear cut off where another cell contains data; the full entry remains in the formula bar when you select the cell. Turning off wrapping is not required just to enter a manual height, but it is the most dependable way to prevent long text from needing extra row space.
  4. Enter a specific row height. Keep the rows selected and choose Home > Cells > Format > Row Height. In the dialog box, type the height in points, then select OK. For example, 20 sets each selected row to 20 points. A point is a screen-independent typographic measurement, not a number of pixels, so the on-screen appearance can vary with display scaling and zoom. You can reopen the same dialog and try a larger or smaller value if the result is not comfortable to read.
  5. Check the result with real worksheet content. Look at the longest entries, the largest font, and any cells with vertical alignment or borders. If text is clipped, either increase the manual height, reduce the font size, or keep the height and accept that the whole entry will not be visible in the grid. To read a clipped value, select its cell and use the formula bar. If the content must be fully visible inside the worksheet, a fixed height may not suit that row; consider allowing a taller row or placing the full text in a note or a separate detail area.
  6. Avoid running AutoFit on the rows you have fixed. AutoFit can change your manual setting. Do not double-click the boundary below a row number, because that automatically sizes the row to its contents. Also avoid Home > Cells > Format > AutoFit Row Height for those rows. If you use a ribbon shortcut, verify the command shown before activating it; the Row Height command opens a value dialog, while AutoFit Row Height recalculates the size.
  7. Repeat for other sheets if needed. Row height settings apply to the selected rows on the active worksheet. They do not automatically apply to every sheet in the workbook. If several sheets need the same layout, repeat the selection and height steps on each one. You can group worksheet tabs to make matching layout changes across sheets, but be careful: edits made while sheets are grouped can affect all grouped sheets. Ungroup them afterward by right-clicking a selected sheet tab and choosing Ungroup Sheets.

On Excel for Mac, the same general approach applies: select the row headers, switch off Wrap Text on the Home tab if needed, and use the row-height command from the ribbon or the Format menu. Ribbon names and placement can differ slightly by Mac version. In Excel for the web, select the rows and use the Home tab’s Format menu to set Row Height; if the menu is arranged differently in your browser, use Excel’s search box to find the Row Height command. The core limitation is the same: there is no workbook-wide permanent off switch for AutoFit.

Common Mistakes

  • Looking for a global AutoFit off setting. Excel provides commands to set a row’s height or fit it to content, but not a master setting that prevents all resizing commands. The practical fix is to set the needed height and avoid AutoFit commands.
  • Leaving Wrap Text on and expecting every line to show in a short row. Wrapped text needs vertical space. If you force a low height, some lines can be hidden. Turn wrapping off for a fixed-height layout, or choose a height that fits the expected number of lines.
  • Confusing a clipped display with deleted data. Setting a shorter row does not normally erase the cell value. Select the cell and inspect the formula bar before changing or retyping anything.
  • Double-clicking the row boundary to adjust the layout. A double-click on the divider beneath a row number invokes AutoFit. If you want a specific size, use the Row Height dialog instead.
  • Assuming the change applies to the entire workbook. Row heights belong to individual worksheets. Selecting rows on one sheet will not change the same rows on other tabs unless those sheets were deliberately grouped.

Tips

  • Set a consistent height in one operation. Select all rows that should match before opening Row Height. Excel assigns the entered value to every selected row, which is more precise than dragging each boundary by eye.
  • Use a test row first. Try the intended value on a row with typical content and one with a long entry. Once the layout is readable, apply that height to the other relevant rows. This avoids making a large range too short and then having to restore it.
  • Keep a copy of the original layout. If the sheet has carefully adjusted heights, duplicate the worksheet before changing many rows. This gives you a quick reference for the original design and a way to recover if the new layout is unsuitable.
  • Consider the viewing task. A compact fixed height can make a table easier to scan or print, but it is less useful when users must read long descriptions directly in cells. You can keep the table rows compact while using the formula bar, a separate detail column, or a larger row for selected records.
  • Remember that zoom does not set row height. Changing the zoom percentage changes how large the worksheet appears on screen; it does not change the stored height in points. If a row looks different on another display, check its Row Height value rather than using zoom as a layout fix.

Troubleshooting

The row changes after I set its height. Check whether you or another user applied AutoFit, used a template or macro that changes row dimensions, or pasted formatting from a different range. Undo immediately with Ctrl+Z on Windows if the unwanted change just happened. Otherwise, select the affected rows and enter the required value again under Home > Cells > Format > Row Height. If the workbook is shared, ask whether another edit or automation is changing the layout.

The row is fixed, but text is missing from view. First select the cell and look at the formula bar to confirm the value is still present. Turn off Wrap Text if you prefer one-line display, or increase the row height if wrapped lines need to be visible. Remember that text in a neighboring cell can block overflow, and narrow columns can make a long entry appear incomplete even when the row height is correct. Row height controls vertical space; widening the column may be the better fix for a one-line entry.

AutoFit does not make a wrapped cell tall enough. Check for merged cells. Excel may not AutoFit row height correctly for cells merged across columns, because the text spans multiple cells. Unmerge the cells if practical, then use Wrap Text and AutoFit Row Height; or keep the merge and set a suitable row height manually. Also check whether the text contains manual line breaks, which can require more space than a single line.

I cannot find the Row Height command. Make sure you are on the Home tab and have selected worksheet rows rather than only a chart or shape. In Windows desktop Excel, look in Home > Cells > Format. In Excel for the web or on Mac, use the Home or Format menus, or search for Row Height using the command search box if available in your version. If the sheet is protected, the command may be unavailable; ask the workbook owner to allow formatting rows or unprotect the sheet with the appropriate password.

The row height looks different when printed or on another computer. Confirm the numeric height in the Row Height dialog and check the workbook’s font, printer scaling, and page setup. Zoom affects only the on-screen view, while print scaling can change how much content fits on a page. If the issue is readability in print, review Print Preview and adjust page scaling or column widths rather than repeatedly changing the row height without checking the printed result.

Frequently Asked Questions

Can I permanently turn off AutoFit row height in Excel?
No. Excel has no general setting that disables every AutoFit command. Set manual heights and avoid AutoFit Row Height or double-clicking row boundaries when you want to retain them.

Will Excel automatically change a row when I type more text?
It depends on the cell formatting and how the row is sized. Wrapped text can need more space, while a manually set height may leave some content out of view. For predictable fixed-height rows, turn off Wrap Text and set the height explicitly.

Can I make every row in a worksheet the same height?
Yes. Select the whole worksheet with the Select All button, then choose Home > Cells > Format > Row Height and enter a value. This changes all rows on that sheet, including rows that may not currently contain data.

What is the difference between Row Height and AutoFit Row Height?
Row Height assigns the point value you enter. AutoFit Row Height calculates a height based on the cell contents and formatting. Use Row Height for a controlled layout and AutoFit when the content should determine the space.

Does this work in Excel for Mac and Excel for the web?
Yes, both allow you to set row height manually, although the menu placement can vary. Select the rows and use the Row Height command. Neither version provides a permanent switch that disables all AutoFit behavior.

Can I keep text wrapped and still use a fixed row height?
Yes, but the row may not be tall enough to show every wrapped line. Set the height you want and check the cell contents. If complete visibility matters, allow more height or use a different layout.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.