Excel Column Height: What It Means and How to Set It

How-to basics · Updated November 18, 2026

Excel columns do not have individual heights: each column runs down the worksheet, while height is set for rows. To change the vertical space used by cells in a column, select the relevant row or rows and choose Home > Format > Row Height, or use AutoFit Row Height to fit their contents.

Why Excel Has Row Height, Not Column Height

An Excel worksheet is arranged as columns and rows. A column is a vertical strip of cells, identified by a letter such as A or B; a row is a horizontal strip, identified by a number such as 1 or 2. The cell at the intersection of column A and row 1 is A1. Excel sets the width of columns and the height of rows, not the height of an individual column.

That distinction matters when you are trying to make one column look taller. If you increase the height of row 5, every cell in row 5 becomes taller, including cells in columns A, B, and beyond. You cannot make only the cell in column B taller while leaving the other cells in that same row at a different height. If your goal is to provide more room for text in one column, you can widen that column, wrap its text, or increase the height of the rows containing those cells.

Excel worksheets have 1,048,576 rows and 16,384 columns. Each row has one height across the sheet, and each column has one width. This grid structure is why Excel describes vertical sizing as row height, even when the visible problem appears to be inside a particular column.

How Excel Measures Row Height

Row height is measured in points, a typographic unit equal to 1/72 of an inch. A common default is 15 points, although the exact default can depend on the workbook’s settings and default font. The height you see on screen in pixels can also look different with display scaling or zoom, but changing zoom does not change the row’s stored height in points.

Column width uses a different unit. It is based on the approximate number of characters of the worksheet’s default font that fit in the column, rather than a fixed number of points. Therefore, a width value and a height value are not directly comparable. For example, setting a row to 30 points makes it twice the height of a 15-point row; setting a column width to 30 does not mean 30 points or 30 pixels.

Excel allows a row height up to 409 points. A row can also be hidden by setting its height to zero, though hiding and setting a small positive height are different: a hidden row does not display its cells until it is unhidden.

Set a Specific Row Height

For a precise height in Excel for Microsoft 365 on Windows, select the row or rows first. Then use the Home tab’s Format menu:

  1. Click a row number at the left edge of the worksheet to select that row. Drag across row numbers, or hold Ctrl while clicking separate row numbers, to select multiple rows.
  2. Choose Home > Format > Row Height in the Cells group.
  3. Type a value in points and select OK.

The entered height applies to the selected rows across all columns. For example, selecting row 8 and entering 30 makes the entire eighth row 30 points high, not just the cell where you noticed clipped text. To apply one height to every row, select the whole worksheet using the triangle at the top-left corner of the grid, then set Row Height. Be aware that this changes every row, including rows that were intentionally sized differently.

On Windows, the ribbon access-key sequence Alt+H, O, H opens the Row Height command; press the keys in sequence rather than together. Alt+H, O, A runs AutoFit Row Height. These ribbon shortcuts can depend on the active interface and language. On Mac, use Home > Format > Row Height or the equivalent Row > Height command in the menu bar; Windows Alt sequences do not apply. Excel for the web also provides row-height and AutoFit options through its formatting controls, although the layout can differ from the desktop ribbon.

Use AutoFit for Text and Other Cell Content

AutoFit adjusts a row’s height to display the content that needs the most vertical space in that row. To use it, select one or more row numbers and choose Home > Format > AutoFit Row Height. You can also move the pointer to the boundary below a row number and double-click when the vertical resize pointer appears. When multiple rows are selected, double-clicking a boundary can AutoFit the selected rows.

AutoFit is useful when cell contents vary in length. Suppose B4 contains a short label, while B5 contains a longer note. If column B is narrow and Wrap Text is enabled for B5, AutoFit can increase row 5’s height so more lines of the note are visible. Without wrapping, long text may spill visually into neighboring empty cells, or appear cut off if the next cell contains data; increasing row height alone will not make a single unwrapped line wrap.

AutoFit is a calculation based on cell contents and formatting, not a promise that every object will fit. It can be unreliable with merged cells, and it does not necessarily size a row to accommodate an overlaid picture or shape. If the result is too short or too tall, set a height manually or adjust the cell layout. Changing the font, font size, column width, or wrapping can also change the height AutoFit chooses.

Make a Column’s Text Fit Vertically

If the real aim is to read more text in one column, the usual solution combines column width, wrapping, and row height. Select the relevant cells or the column, turn on Home > Wrap Text, and then AutoFit the rows that contain the text. Wrap Text breaks a cell’s contents onto additional lines within the existing column width. The row then needs enough height to show those lines.

For example, imagine a comments column that is 20 characters wide and contains a two-sentence note. Widening the column may reduce the number of wrapped lines, but it also takes space away from neighboring columns. Keeping the column narrow and wrapping the text can preserve the worksheet’s overall layout, at the cost of taller rows. A row height chosen manually may be preferable if you want consistent heights for printing or for a report-style table.

Alignment settings can affect what appears visible. Shrink to Fit reduces the displayed text size to fit a cell’s width; it does not make a column taller. Vertical alignment changes where content sits within the row, but does not create extra room. If text is still not readable, check the row height, wrapping, font size, and column width rather than looking for a column-height setting.

Change Several Rows or Keep Heights Consistent

To give a group of rows the same height, select their row numbers and set one value through Home > Format > Row Height. This is useful for making a data-entry form or a printed schedule look regular. The selection can include adjacent rows by dragging over their headers, or nonadjacent rows by holding Ctrl while selecting each one on Windows. On Mac, use Command to select separate rows.

There is a practical tradeoff between equal heights and AutoFit. AutoFit is best when the worksheet must show variable amounts of text; a fixed height is best when visual consistency matters more. If a fixed-height row is too short for a long entry, Excel may show only part of the content in the cell. You can still select the cell and read its full value in the formula bar, but that does not solve the visibility problem for someone viewing or printing the sheet.

For a large table, consider applying Wrap Text to the relevant column and then AutoFitting the table’s rows. Avoid selecting the entire worksheet unless you intend to change every row. A uniform height can remove carefully adjusted spacing elsewhere, while AutoFit across a very large sheet may produce many unusually tall rows if some cells contain long notes.

Common Row-Height Problems

If a row will not become taller, first check whether the worksheet is protected. Protection settings can prevent formatting changes. If the row number is missing, the row may be hidden or set to zero height; select the rows above and below it, then use Home > Format > Hide & Unhide > Unhide Rows. You can also select the surrounding rows and set a positive height.

If text remains clipped after AutoFit, check whether Wrap Text is enabled and whether the cell is merged with neighboring cells. AutoFit does not reliably calculate the correct height for merged cells. A workaround is to unmerge the cells, use a wider column or manual row height, or place the text in a layout that does not depend on a merged cell. Also verify that the text is actually in the cell you expect; a neighboring cell’s contents can affect how unwrapped text appears.

Copied formatting can change row heights unexpectedly. Pasting cells from another worksheet may bring their formatting along, depending on the paste option used. If a row suddenly looks different, select it and set a known height, or use AutoFit after checking its text and wrapping. If you are working in a filtered list, some rows may not be visible; changing selected rows does not necessarily make hidden or filtered-out records appear.

Row Height Versus Column Width

Row height controls vertical space; column width controls horizontal space. To change width, select a column letter and choose Home > Format > Column Width, or drag the boundary between column letters. Double-clicking that boundary uses AutoFit Column Width, which sizes the column to its contents. These commands are separate from Row Height and AutoFit Row Height.

Use column width when a heading or value is cut off horizontally and you want more room across the sheet. Use row height when wrapped lines or vertical spacing need room. If neither adjustment is suitable, alternatives include changing the font size, wrapping text, rotating text, or placing long explanatory text in a separate notes column. Each option changes the layout differently, so consider whether the worksheet is intended for on-screen reading, data entry, or printing.

Frequently Asked Questions

Can I change the height of just one Excel cell?
No. Height belongs to the whole row, so changing it affects every cell in that row. You can make one cell’s text take less or more vertical space through wrapping, font, or alignment, but its row height remains shared.

How do I make all rows the same height?
Select the worksheet or the row numbers you want to change, choose Home > Format > Row Height, enter a value in points, and select OK. Selecting the entire worksheet changes rows throughout the sheet, so use a smaller selection if other sections need different heights.

Why does AutoFit not work for my row?
Check for merged cells, disabled Wrap Text, protection, or content that is an overlaid object rather than cell text. Merged cells are a common cause of unreliable AutoFit. Set the height manually or change the layout if AutoFit still does not show all the content.

What is the default Excel row height?
A common default is 15 points, but the workbook’s default font and settings can affect the default. Existing rows may also have been manually resized, so the height of a row in a particular file need not match the default.

Does Excel column width use the same units as row height?
No. Row height is measured in points, while column width is based on character width using the worksheet’s default font. A column-width value of 20 therefore does not mean 20 points or 20 pixels.

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.