Excel Column Width and Row Height: Are They Equal?

No. Excel column width and row height use different units, so entering the same number for each does not make a square cell. Column width is based on characters in the worksheet’s default font, while row height is measured in points; the two settings need to be adjusted separately.

What Excel means by column width and row height

In Excel for Microsoft 365 on Windows, a column’s width is a character-based measure, not a direct measurement in inches or points. It is related to how many characters of the digit zero in the worksheet’s Normal style font can fit across the cell, with additional spacing built into the calculation. The exact screen width therefore depends on the font and its size, as well as Excel’s display scaling.

Row height, by contrast, is measured in points. A point is 1/72 of an inch, so a row height of 15 means 15 points, not 15 pixels. Excel translates that point measurement into screen pixels when displaying the sheet. At common display settings, a standard row height of 15 points appears roughly 20 pixels tall, but the apparent pixel size can vary with display scaling and zoom.

These different measurement systems explain why the numbers shown in the Column Width and Row Height boxes cannot be compared as if they were the same kind of length. A width of 15 is not 15 points, and a height of 15 is not 15 character units.

Why equal numbers do not make square cells

A spreadsheet cell is the rectangle formed by the width of its column and the height of its row. Excel does not treat the value in the Column Width box as a point measurement, so setting a column to 15 and its row to 15 does not produce equal horizontal and vertical dimensions. The row value describes a physical point-based height; the column value describes a font-dependent width.

Even if a column and row look close to square on one computer, they might not look square on another. Font choice, font size, screen resolution, Windows display scaling, and worksheet zoom all affect how the grid appears. Zoom changes how large the sheet looks on screen, but it does not change the underlying column-width or row-height settings.

This distinction matters for layouts such as calendars, pixel-art grids, seating plans, and forms that use cells as visual blocks. Matching the displayed numbers is not a reliable method. Instead, adjust the actual on-screen proportions, or use a consistent setup and check the result at the intended display or print size.

How to change a column width or row height

To enter a specific value in Excel for Microsoft 365 on Windows, select the relevant column or row first. You can select a whole column or row by clicking its letter or number heading. To apply one setting to several columns or rows, select all of their headings before opening the sizing command.

For a column, go to Home > Cells > Format > Column Width, enter a value, and select OK.
For a row, go to Home > Cells > Format > Row Height, enter a value, and select OK.
To adjust by eye, place the pointer on the boundary between column headings or row headings and drag it. Excel displays a sizing indicator as you move the boundary.

You can also double-click the boundary between two column headings to fit the column to its contents, or double-click the boundary between row headings to fit the row height. If several columns or rows are selected, the AutoFit action can adjust each selected one to its own contents. Keyboard users on Windows can use the ribbon sequences Alt, H, O, W for Column Width and Alt, H, O, H for Row Height; these are sequential key presses, not keys held down together.

Excel for Mac has the same basic options, though ribbon layout and keyboard shortcuts can differ by version and keyboard configuration. Excel for the web also provides row- and column-sizing controls, but its interface may not match the Windows desktop ribbon exactly. If a shortcut does not work in your edition, use the Format controls or drag the heading boundary.

How to make cells look square

There is no universal pair of equal numbers that makes square cells in every workbook. A practical approach is to set a column width, adjust the row height until the cell looks square at the zoom level you plan to use, and then check a few cells across the sheet. For a grid of many cells, apply the same column width to the selected columns and the same row height to the selected rows.

For example, a teacher making a simple grid for a classroom activity might set several columns to a narrow width, then increase the corresponding row heights until the printed boxes look roughly square. The precise settings will depend on the font and print layout. If the grid must be physically square on paper, use Print Preview or a test print and measure the output; on-screen appearance alone is not a guarantee of print dimensions.

Keep in mind that selecting a different font or changing the Normal style can alter how a character-based column width appears. Likewise, changing zoom alters the apparent size of both dimensions without changing their stored values. For repeatable results, keep the font, display conditions, and print scaling consistent while adjusting the grid.

Using AutoFit and understanding its limits

AutoFit is useful when the aim is to show cell contents, rather than to make a geometric shape. To AutoFit a column, select it and choose Home > Cells > Format > AutoFit Column Width. For rows, use Home > Cells > Format > AutoFit Row Height. Double-clicking the relevant heading boundary is a quicker alternative for a small number of rows or columns.

AutoFit uses the contents of the cells to decide a suitable size. A long entry can make a column much wider than expected, while wrapped text can require a taller row. If text wrapping is enabled, adjust the column width first and then AutoFit the row height so Excel can calculate the height needed for the wrapped lines.

Merged cells are a common complication: AutoFit may not size rows or columns as expected when the content spans merged cells. For a layout that needs reliable resizing, consider unmerging the cells and using another alignment option, or set the row height and column width manually. Also check whether a row or column is hidden before assuming that AutoFit failed; hidden headings and zero-sized dimensions are not visible on the grid.

Common sizing problems and what to check

If a column looks too narrow after you enter a width, remember that the number is not a pixel count. Try a larger value or drag the boundary until the content fits. If a row clips text, check whether wrapping is on and whether the row has a fixed height that prevents all lines from showing. AutoFit can help with ordinary cells, but it cannot resolve every layout issue involving merged cells or manually constrained dimensions.

Text is cut off: Widen the column, turn on Wrap Text, or use AutoFit. A neighboring cell containing data can also prevent text from visibly overflowing into that space.
Rows are unexpectedly tall: Look for wrapped text, a large font, or a line break in a cell. AutoFit may increase the height to show the content.
Several columns changed together: More than one column may have been selected. Check the highlighted headings before entering a width.
The sheet looks different when printed: Review page orientation, margins, scaling, and Print Preview. Printing can resize the sheet to fit a page, changing its apparent proportions.

Excel also has maximum dimensions for these settings: a column width can be up to 255 character units, and a row height can be up to 409 points. These limits are far beyond typical worksheet layouts, but they explain why an unusually large requested size may stop increasing at a maximum.

Column width, row height, pixels, and print size

Pixels are useful for thinking about what appears on screen, but they are not the native units used by the two Excel sizing boxes. A pixel is a screen-display unit whose physical size depends on the display. Excel’s column width is tied to font metrics, and its row height is stored in points. As a result, converting a column-width number directly into points or pixels requires assumptions about the font and display environment.

Printing adds another layer. Page setup can scale a worksheet to fit a page or a specified number of pages, making cells print smaller or larger than their on-screen appearance suggests. If precise printed dimensions matter, set the worksheet layout, use Print Preview, and verify the output with a test print when necessary. If the task is only to improve readability on screen, adjust the grid at the zoom level people will actually use.

Frequently Asked Questions

Is Excel column width measured in pixels?
No. Excel presents column width in character-based units related to the worksheet’s default font. Its on-screen pixel appearance depends on font metrics and display settings.

Is row height measured in pixels or points?
Row height is measured in points, with 72 points equal to one inch. Excel renders that height on screen as pixels, so the visible pixel count can vary with display scaling.

What is the default row height in Excel?
A common default is 15 points, but the default can vary with the workbook’s font settings and formatting. A row that has been manually resized also will not necessarily use the default height.

Can I make every Excel cell a perfect square?
You can make a grid look square by adjusting column widths and row heights, but there is no single setting that guarantees square cells on every screen or printer. Use the same dimensions across the selected grid and check the result at the intended zoom or print size.

Why does AutoFit not resize a merged cell correctly?
AutoFit can be unreliable when content spans merged cells because the content does not belong to one ordinary cell dimension in the usual way. Set the row height manually or redesign the layout without merged cells if accurate automatic sizing is important.

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.