Excel row height is measured in points, not pixels: one point is 1/72 of an inch. A typical worksheet row is 15 points high, though the default can vary; you can enter a precise height or use AutoFit to size a row to its contents.
What unit does Excel use for row height?
In desktop Excel, the Row Height setting is expressed in points. This is a typographic unit used for print and screen layout: 72 points make one inch. The number shown in the Row Height dialog therefore describes the row’s height in points, not the number of pixels you will see on your monitor.
A row has one height shared by all its cells. For example, setting row 4 to 30 points makes every cell in row 4 occupy that row height, whether the cells contain text, numbers, dates, or nothing. You can select one row or several rows before applying a height. If several rows are selected, the same specified height is applied to each selected row.
Row height is also different from font size. A 12-point font does not require a 12-point row: the row needs enough room for the font’s visible characters, line spacing, and any wrapped lines. Borders and cell formatting can affect what fits visually, but they do not change the unit used in the Row Height dialog.
Points, inches, and centimeters
Because points are physical units, you can convert a row height into an approximate printed measurement. Divide the point value by 72 to get inches, or by about 28.35 to get centimeters. For example, a 36-point row is half an inch high, while a 15-point row is about 0.208 inch, or 0.53 centimeter.
These conversions are useful when preparing forms, labels, or reports that need consistent printed spacing. They do not guarantee that every printed page will have the same overall dimensions as the worksheet on screen: print scaling, margins, paper size, and printer settings can all change the final output. The point value is the row’s layout measurement before those print adjustments.
Excel does not use the same unit for column width. Column width is based primarily on the width of characters in the workbook’s default font, which is why a column width such as 10 does not mean 10 points or 10 pixels. This difference often causes confusion when someone tries to make a row and a column the same numeric size.
Why row height looks like pixels on screen
Excel has to render a point-based row as screen pixels. At a nominal 96 pixels per inch, one point corresponds to about 1.33 pixels, so a 15-point row would occupy roughly 20 pixels. That is only a useful estimate, not a promise about the exact number of pixels you will see.
Display scaling, screen resolution, Excel’s zoom level, and the operating system’s rendering can change the apparent on-screen size. Increasing worksheet zoom makes rows look larger in the window, but it does not change the row height stored in the workbook. Likewise, a row that looks 20 pixels tall on one display may not look that way on another.
If you need a particular physical height for printing, set the height in points rather than measuring the row on your monitor. If you need a particular screen appearance, adjust the row height and zoom together, then check the result on the intended display. Pixel estimates are useful for rough comparisons, but the Row Height value remains the reliable measurement in Excel.
Typical defaults and the height limit
A common default row height is 15 points, but do not assume every workbook will use that value. The default depends on workbook formatting and the font used for the Normal style, and it can differ between files or after changes to workbook defaults. Existing rows may also have been resized by a user, a template, or pasted formatting.
To check a particular row, select it and open the Row Height dialog. The displayed value is more useful than relying on a remembered default. The maximum row height in Excel is 409 points. A row with a height of zero is hidden; hiding a row is not the same as deleting its contents.
- 15 points: a familiar default in many workbooks, but not universal.
- 30 points: twice the height of a 15-point row, often enough for two short wrapped lines depending on the font and column width.
- 409 points: Excel’s maximum row height.
- 0 height: the row is hidden, while its cell contents remain in the worksheet.
How to set an exact row height
In Excel for Microsoft 365 on Windows, select the row or rows by clicking their row numbers, then choose Home > Format > Row Height. Enter a value in points and select OK. You can also right-click a selected row header and choose Row Height. Selecting the entire sheet first applies the height to all rows, so use that option deliberately.
- Click a row number to select one row. Drag across row numbers or hold Ctrl while clicking to select separate rows.
- Choose Home > Format > Row Height, or right-click a selected row header and choose Row Height.
- Enter the desired point value and confirm. To hide a row, use the Hide command or set its height to zero.
For a quick visual adjustment, drag the boundary below a row number. To resize multiple selected rows by eye, drag the boundary of one of the selected rows. These approaches are convenient, but the dialog is better when you need an exact value or consistent sizing across a workbook.
In Excel for Mac, select the row and use the row-header context menu or the Home tab’s Format controls to choose the row-height command; labels and menu placement can differ slightly between builds. In Excel for the web, select or right-click a row header and use the resize-row option. The web interface may offer a pixel-oriented resize field, so it is not identical to the desktop dialog’s point-based presentation.
AutoFit and content-based sizing
AutoFit tells Excel to choose a row height based on the cell contents and formatting. On Windows, select the relevant rows and choose Home > Format > AutoFit Row Height. You can also double-click the boundary below a row number to AutoFit that row. When several rows are selected, AutoFit can adjust them to their individual contents.
AutoFit is especially useful after turning on text wrapping or changing a column width. A sentence that fits on one line in a wide column may become two or three lines in a narrower one, so the required row height changes. AutoFit recalculates the height from the current layout rather than using a single fixed value for every row.
It is not always necessary to run AutoFit after every edit: wrapped text may cause a row to expand as its contents change. However, a manually assigned height can prevent Excel from showing all wrapped lines, and the row may not resize as expected after later edits. If text is clipped, select the row and run AutoFit again, or set a larger height yourself.
AutoFit is a sizing convenience, not a guarantee that every cell will be displayed perfectly in every situation. It can produce a large row when one cell contains a long passage, and it may not give the result you want for merged cells. Review the result after changing fonts, column widths, or wrapping.
Wrapped text, merged cells, and clipped content
When Home > Alignment > Wrap Text is enabled, Excel can display long cell contents on multiple lines within the same cell. The column width determines where the text wraps; the row height determines how many of those lines can be seen. If the row is too short, text may appear cut off even though the full value remains in the cell.
Merged cells are a common complication. A merged cell spans more than one column, which makes it difficult for Excel to calculate a suitable AutoFit height. AutoFit may fail to expand a row enough to display all the wrapped text in a merged cell. If that happens, set the row height manually, widen the merged area, or consider avoiding the merge and using a layout that leaves the cells unmerged.
Also check whether a cell contains a line break inserted with Alt+Enter on Windows. A manual line break forces a new line even when the text would otherwise fit, so it can increase the required height. The Mac keyboard combination for inserting a line break can differ by Excel build and keyboard layout; use the appropriate Excel shortcut for that installation.
Row height when printing
Points are useful for print layout because they correspond to physical dimensions: 72 points equal one inch. Still, a 36-point row will not necessarily print at exactly half an inch on the finished page if the worksheet is scaled to fit, or if the print setup changes the output size. Check Page Layout settings and print preview when exact page composition matters.
Paper size, margins, print area, and scaling options can affect how much of the worksheet fits on a page. A row that looks spacious on screen may also break across pages in an unexpected place. Use print preview to inspect page breaks and readable text before distributing or printing a report. Changing zoom affects the worksheet view, not the page scaling used for printing.
Common row-height problems and fixes
- Text is cut off: check Wrap Text, the column width, and whether the row has a fixed height. Then use AutoFit Row Height or enter a larger height.
- AutoFit does not work on a merged cell: set the height manually or revise the layout so the text is not in a merged range.
- Rows look different on another computer: font availability, display scaling, zoom, and screen resolution can affect appearance. Compare the actual point values rather than screen pixels.
- A height change affects more cells than expected: row height belongs to the entire row, not to an individual cell. Put content in separate rows if it needs different vertical spacing.
- A row seems to have disappeared: it may be hidden or have zero height. Select the surrounding row headers, then use the Unhide command from the row-header context menu.
When a row refuses to display what you expect, first distinguish between a layout issue and a missing value. The contents may still be present even if the row is hidden or too short. Select the cell and inspect the formula bar, then check the row height, wrapping, merged-cell status, and column width.
Frequently Asked Questions
Are Excel row heights measured in pixels?
No. Desktop Excel measures row height in points. Pixels are only an approximate way to describe how tall a row looks on a particular screen.
How many pixels is a 15-point row?
At a nominal 96 pixels per inch, 15 points is about 20 pixels. Actual on-screen appearance varies with display scaling, resolution, and zoom.
What is the default row height in Excel?
Fifteen points is common, but the default can vary with workbook settings and the Normal style’s font. Check the Row Height dialog for the actual value in a specific workbook.
How do I make every row the same height?
Select the rows you want, then choose Home > Format > Row Height on Windows, enter the point value, and confirm. Selecting the sheet before setting the value applies it across the worksheet.
Why does AutoFit not show all the text?
A fixed row height, merged cells, or a layout that wraps text across a narrow column can prevent the expected result. Try AutoFit again, widen the column, or set the row height manually; merged cells often need manual sizing.
Related
- Data Validation Checks in Excel: Rules and Examples
- Data Validation Checklist for Excel: What to Check
- Conditional Formatting in Microsoft Project: What Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Outlook: Can You Schedule an Email to Be Sent?Yes. Outlook lets you schedule an email to be sent later, although the steps and where the message…
- Google Sheets: Delete Conditional Formatting RulesYes. In Google Sheets in a web browser, select a cell or range, open Format > Conditional formatting,…
- Google Sheets Google Translate Formula: How to Use ItIn Google Sheets, translate text with GOOGLETRANSLATE. With the text in A2 and a Spanish translation wanted in…
- How to Edit a Mail Merge Document in WordTo edit a mail merge in Word, open the main merge document, change its text or merge fields,…
- How to Set an Out of Office Reply in Outlook 365To set an out of office reply in Outlook 365, open Automatic Replies, switch them on, write your…
- Insert an Electronic Signature in WordTo insert an electronic signature in Word, add a picture of your handwritten signature, draw one with the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.