Excel Row Size: Row Limits, Height, and AutoFit Explained

In Excel for Microsoft 365, a worksheet can contain up to 1,048,576 rows, and an individual row can be up to 409 points high. If by “row size” you mean how tall a row appears, Excel measures that height in points; if you mean how many rows a sheet has, the limit is just over one million.

What “row size” means in Excel

People use “row size” to mean two different things: a worksheet’s row capacity or the height of a particular row. These are separate limits. The row capacity is fixed for a worksheet, while row height is a formatting setting you can change to fit text, improve readability, or prepare a sheet for printing.

Height is measured in points, a typographic unit. A point is 1/72 of an inch, so 15 points is roughly 0.21 inches in physical terms. The number of screen pixels used to draw a row can vary with display scaling, zoom, and screen resolution. That is why a point value is more dependable than an estimate such as “about 20 pixels.”

Row height is also different from column width. Excel expresses row height in points, but column width is based on the width of characters in the worksheet’s default font. A row’s height does not tell you how wide its cells are, and changing a column width may affect how much wrapped text fits vertically.

How many rows an Excel worksheet has

A worksheet in current Excel versions, including Microsoft 365, has 1,048,576 rows, numbered from 1 through 1,048,576. It also has 16,384 columns, ending at column XFD. Those are worksheet grid limits, not a guarantee that a workbook can perform quickly with data in every cell; practical speed depends on the computer, workbook design, formulas, formatting, and other factors.

Older file formats have smaller limits. Excel 97–2003 workbooks saved in the .xls format support 65,536 rows and 256 columns. If you open or save a workbook in that compatibility format, data beyond the older limits may not be retained. For a modern workbook with the full grid, use the .xlsx format, or .xlsm if the workbook needs macros.

Adding rows to a table does not increase the worksheet’s maximum capacity. It makes a selected data range easier to sort, filter, and extend, but the table still occupies ordinary worksheet cells. Similarly, deleting data from the bottom of a sheet does not create additional row numbers beyond the grid limit.

Excel’s row-height range and default height

Excel allows a row height from 0 to 409 points. A height of zero hides the row; it is not a useful visible height. The maximum of 409 points is approximately 5.68 inches, though its on-screen appearance depends on display settings. A row can be made very tall, but that does not enlarge the worksheet’s row-count limit.

Many worksheets start with a default height of about 15 points. The actual default can vary with the workbook’s default font and other workbook settings, so an existing sheet may not match that figure exactly. A row with a larger font, wrapped text, or manually assigned formatting may also be taller than the default.

Excel can adjust a row automatically when its contents or formatting need more vertical room. This is useful for wrapped paragraphs and larger text. It does not mean every row continually changes to match its content: a row may have a manually set height, and AutoFit may not calculate the desired result for certain layouts, such as cells merged across multiple rows or columns.

Change a row’s height manually

To set a precise height in Excel for Microsoft 365 on Windows:

Select the row or rows by clicking their numbered headings on the left. To select several adjacent rows, drag across the headings or select the first heading and Shift-click the last.
Choose Home > Format > Row Height.
Enter a value in points, then select OK.

For example, entering 30 makes a selected row twice as tall as a 15-point row. Selecting multiple row headings applies the entered height to all selected rows. If the entered value is above Excel’s permitted maximum, Excel cannot set that height.

You can also drag the boundary below a row number to change its height by eye. To give several selected rows the same height, drag the boundary of one of the selected headings. This is convenient for a quick visual adjustment, while the Row Height dialog is preferable when you need a consistent, repeatable measurement.

On Windows, the keyboard sequence Alt, H, O, H opens the Row Height command when entered as Excel ribbon key tips; type the height and press Enter. The equivalent sequence is not the same on Mac. In Excel for Mac, select the rows and use the Home tab’s Format controls or the row-heading context menu to open the height setting. Ribbon labels and available controls can vary slightly by platform and update.

Use AutoFit to match content

AutoFit sets a row’s height to show the cell contents that Excel can measure. Select the rows, then choose Home > Format > AutoFit Row Height. On Windows, Alt, H, O, A is the corresponding ribbon key-tip sequence. You can also double-click the lower boundary of a selected row heading to AutoFit that row; selecting several rows first applies the adjustment to them together.

AutoFit is most useful when a cell contains wrapped text or a font larger than the row’s current height. For wrapping, select the relevant cells and choose Home > Wrap Text, then AutoFit the rows if needed. Excel can increase the row height to display multiple lines while keeping the column width unchanged. If you later widen the column, the text may fit on fewer lines and the row may become shorter after AutoFit.

AutoFit is not the same as setting a fixed height. If a cell’s content changes later, a fixed-height row stays at its assigned size unless you adjust it again. Also, Excel does not reliably AutoFit text in merged cells. If a merged heading needs more room, you may need to set the row height manually, revise the merge or layout, or put the text in an unmerged cell and use alignment options instead.

Choose a useful height for common tasks

The best row height depends on what the sheet is for. A compact list of dates and short labels usually needs little vertical space; a report with wrapped descriptions needs more. Consider these practical guidelines:

Short entries: Keep the default height or use a modest increase if the text looks crowded. Consistent heights make a data list easier to scan.
Wrapped descriptions: Set an appropriate column width, turn on Wrap Text, and use AutoFit. This lets the row grow according to the number of displayed lines.
Headings: Use a deliberate height that accommodates the font and alignment. A fixed height is useful when all headings should line up, but check that no text is cut off.
Forms and printed sheets: Choose a height that leaves enough space for reading or writing, then check Print Preview. Screen zoom alone does not show exactly how a page will break when printed.

For example, a narrow column containing a long sentence may wrap into five lines. AutoFit can make that row much taller than its neighbors. If the sheet is meant to be a compact overview, it may be better to widen the column, shorten the displayed text, or keep the full explanation in a separate notes column rather than making one row dominate the page.

Common row-size problems

Text appears cut off: The row may have a fixed height that is too small, or the column may be too narrow for unwrapped text. Try Wrap Text and AutoFit Row Height, or adjust the row height manually. Check that the text is actually in the cell and not obscured by another object or a nearby merged-cell layout.

AutoFit does not make a merged heading tall enough: This is a known limitation of how Excel measures merged cells. Set the height manually or redesign the heading so the text is not in a merged range. If a precise layout is important, test it in the printed view as well as on screen.

A row seems to disappear: It may be hidden or set to zero height. Select the row headings on either side of the missing row, then choose Home > Format > Hide & Unhide > Unhide Rows. You can also select the surrounding rows, right-click a heading, and choose Unhide. A filter can hide entire records too, so clear or review the filter if the missing row is part of a list.

Row height changes after a paste: Pasting cells can bring formatting along with the data, including row height in some copy-and-paste situations. If the result is unexpected, inspect the row height and cell formatting. Use Paste Special when you want to control which parts of the copied cells are applied.

Excel for the web and other versions

Excel for the web uses the same general distinction between worksheet row capacity and row height, though its menus and controls may differ from the Windows desktop ribbon. Select the row headings and use the available row-height or resize controls in the Home menu or context menu. Some desktop-specific keyboard sequences and interface options do not apply in a browser.

Excel for Mac also supports adjusting row height, but Windows Alt-based ribbon key tips are not Mac shortcuts. Use the Mac ribbon or row-heading context menu. For a workbook opened in an older Excel release or saved as .xls, remember that its row and column capacity can be lower than the modern worksheet limit.

Frequently Asked Questions

What is the maximum row height in Excel?
Excel’s maximum row height is 409 points. The displayed pixel size varies with screen scaling and other display settings.

How many rows are in an Excel sheet?
A worksheet in Microsoft 365 and other modern Excel versions has 1,048,576 rows, numbered 1 to 1,048,576. Excel 97–2003 .xls sheets have a limit of 65,536 rows.

How do I make all rows the same height?
Select the row headings you want to change, choose Home > Format > Row Height, enter the height in points, and select OK. To apply it to the whole worksheet, select the entire sheet first, then set the row height.

How do I automatically resize Excel rows?
Select the rows and choose Home > Format > AutoFit Row Height. For wrapped text, make sure Wrap Text is enabled. Merged cells may not AutoFit as expected, so a manual height or a different layout may be needed.

Why is text still hidden after AutoFit?
Check for merged cells, a manually fixed height, text wrapping that is turned off, or a column too narrow for the content. Also make sure the row is not hidden. For merged cells in particular, set the height manually or avoid merging the cell containing the text.

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.