Excel Cell Size in CM: What the Measurements Mean

Excel does not give every cell a single size in centimeters. A cell’s width comes from its column-width setting, measured mainly in character units, while its height comes from a row-height setting measured in points; as a practical guide, a 15-point row is about 0.53 cm tall, and a default-width column is roughly 1.7 cm wide on a 96-DPI display.

Why Excel Does Not Show One Cell Size

Excel worksheets are grids, but their dimensions are controlled by whole rows and columns. Changing a column’s width changes the width of every cell in that column. Changing a row’s height changes the height of every cell in that row. The apparent size of one cell is therefore the intersection of those two settings, not a separate measurement stored for that cell.

The two settings use different units for historical and practical reasons. Row height is a typographic measurement in points, where 72 points equal one inch. Column width is based on the number of characters of a particular font that fit across the column, with extra space built into the calculation. That means a column-width value such as 8.43 is not 8.43 centimeters, inches, or characters in every font.

For a rough screen-size estimate, Excel’s familiar default column width of about 8.43 units is approximately 64 pixels in a common default-font setup. At 96 pixels per inch, 64 pixels are about 1.69 cm. This is a useful estimate, not a guarantee of the physical width on every monitor or in a printed worksheet.

Convert Row Height from Points to Centimeters

Points convert directly to centimeters: multiply the point value by 2.54 and divide by 72. For example, a row height of 15 points works out to 15 × 2.54 ÷ 72, or approximately 0.529 cm. A 30-point row is about 1.058 cm. The result describes the row’s specified height, rather than the visible size of text inside it.

Excel’s displayed row height can vary with the workbook’s font and formatting. A row may also become taller when you use wrapped text, merge cells, or set a larger font. If you need a particular row height, select the row and use Home > Format > Row Height. Enter the height in points, not centimeters. To convert a desired height in centimeters to points, multiply the centimeters by 72 and divide by 2.54.

For example, if a form needs a row about 1 cm high, convert 1 cm to roughly 28.35 points, then enter a value near 28.35 in the Row Height box. Excel may display or apply a rounded value, and the result can look slightly different on screen because zoom and display scaling affect how points are drawn.

Convert Column Width to an Approximate Centimeter Size

There is no universal direct conversion from Excel’s column-width number to centimeters because the number depends on the workbook’s Normal style font and its character width. In a common setup using a standard 11-point font, a useful approximation is: first convert the target centimeters to pixels at 96 pixels per inch, then subtract about 5 pixels and divide by about 7. The 5-pixel allowance represents the column’s built-in spacing, while 7 pixels approximates the width of a character in that setup.

For example, a target width of 3 cm corresponds to about 113 pixels at 96 DPI: 3 ÷ 2.54 × 96. Using the approximation, (113 − 5) ÷ 7 gives a column-width setting near 15.4. Entering about 15.4 in Home > Format > Column Width should produce a column around that screen width in the assumed setup. It is an estimate, not a precise physical measurement, and other fonts can shift the result.

For the opposite conversion in the same approximate setup, a width value of 10 corresponds to around 75 pixels because 10 × 7 + 5 is about 75. At 96 DPI, that is roughly 1.98 cm. Treat this method as a planning aid: it is most useful for estimating widths, not preparing a document that must meet a strict physical specification.

Set Measurements Using Excel’s Controls

To enter a specific row height or column width in Excel for Microsoft 365 on Windows, select the relevant row or column and use the ribbon’s formatting commands:

Select one or more row numbers or column letters. You can select several adjacent rows or columns if they should share a size.
Go to Home > Format. Choose Row Height for rows or Column Width for columns.
Enter the value. Row Height accepts points; Column Width accepts Excel’s character-based width units.
Choose OK, then check the result with the intended font, text, and worksheet zoom.

You can also drag the boundary between row numbers or column letters. Dragging is convenient when a visual estimate is enough, but it is less suitable for repeatable measurements. Double-clicking a boundary applies AutoFit, which adjusts the row or column to fit its contents; it does not convert a chosen centimeter measurement. For a whole sheet, use the Select All button at the top-left corner of the grid before entering a row height or column width.

If your goal is to make a printed form with physical dimensions, check the print layout as well. Page scaling, paper size, margins, and printer settings can enlarge or shrink the worksheet. A cell that appears to be a certain size on a monitor may not print at the same physical size if Excel is set to fit the sheet onto a page.

Use Centimeters in Page Layout View

Excel for Windows can display measurement rulers in centimeters in Page Layout view. Open File > Options > Advanced, find the Display section, and set Ruler units to Centimeters. Then select View > Page Layout to see the worksheet with page rulers. This helps when arranging content against a page measurement, though it does not change the underlying column-width unit or turn every cell into a separately measured object.

The ruler is especially useful for positioning columns and rows in relation to a printed page. For closer control, combine it with the Row Height and Column Width commands, then use Print Preview to check the complete page. A ruler reading is still affected by the page setup and printer output; always verify a critical form with a printout or the final PDF.

On Mac, Excel’s menus and preferences differ from Windows, and ruler-unit controls may be found under Excel settings or preferences depending on the version. Excel for the web has a more limited interface and may not offer the same ruler-unit setting. In either case, row heights and column widths still use their respective Excel units, so the centimeter conversions remain estimates rather than a universal built-in setting.

What Changes the Visible Size?

Several factors explain why a cell that has a familiar numerical setting may not measure as expected on screen or on paper:

Font and font size: Column width is tied to the workbook’s standard font metrics. A different Normal style font can change how many characters fit in the same column-width value.
Display resolution and scaling: The relationship between logical pixels and physical centimeters depends on the display and operating-system scaling. A 100% worksheet zoom does not guarantee that a screen ruler matches a physical ruler.
Worksheet zoom: Zoom changes how large cells look on screen, not their stored row-height or column-width settings.
Print scaling: Fit-to-page settings can resize the worksheet during printing or PDF export. The printed size may therefore differ from the screen estimate.
Wrapped or long content: Wrap Text, large fonts, and AutoFit can increase row height or make a column appear too narrow for its contents.
Hidden rows or columns: A hidden row or column has no visible width or height until it is unhidden, even though its formatting may remain stored.

These distinctions matter for labels, forms, and templates. If a column must display a fixed number of characters, its character-based width may be more useful than a centimeter target. If an object must align to a printed page, page layout and print scaling are more important than the apparent size at a chosen zoom level.

Common Misconceptions and Practical Choices

A frequent misconception is that setting a cell to 2 cm means typing 2 into Column Width or Row Height. That does not work: 2 in Row Height means 2 points, and 2 in Column Width means a narrow character-based width. Convert the target first, and remember that column conversion is font-dependent.

Another common assumption is that width and height are independently adjustable for one cell. Excel’s standard grid does not support that. To make one cell appear narrower or taller than its neighbors, you can use a different layout, merge cells carefully, or place a shape or text box over the grid. Merging can complicate sorting, filtering, and selecting data, so it is usually a poor choice for ordinary tabular data.

Choose a method based on what you need:

For a consistent data table, set column widths in Excel units and use AutoFit selectively.
For a form that will be printed, use page rulers, row-height controls, print preview, and a test print.
For a screen-only layout, treat centimeter conversions as estimates and check at the typical zoom and display size.
For repeated formatting across a workbook, enter the same row-height and column-width values directly rather than dragging by eye.

Frequently Asked Questions

How many centimeters is one Excel row?
A row has no fixed centimeter size. Its height is set in points; for example, a 15-point row is approximately 0.53 cm because 72 points equal one inch and one inch equals 2.54 cm.

How wide is an Excel cell in centimeters by default?
There is no single guaranteed default in centimeters. A common default column width of about 8.43 is roughly 1.7 cm on a 96-DPI display in a typical default-font setup, but the font, display scaling, zoom, and printing settings can change the apparent size.

Can I type centimeters into Excel’s Column Width box?
No. The Column Width box uses Excel’s character-based units. Convert a target width to an approximate column-width value, or use the Page Layout ruler to help position content in centimeters.

How do I make an Excel cell exactly 2 cm wide?
Excel does not provide a universal exact conversion because column width depends on font metrics and the displayed or printed output can be scaled. Estimate the width in pixels and convert it to a column-width value, then verify it in Page Layout view or in the final print output.

Does changing zoom change the cell’s actual size?
No. Zoom changes the worksheet’s on-screen appearance, not the row-height or column-width values. Print scaling and page settings, however, can change the size of the worksheet when it is printed or exported.

Bottom Line

For Excel cell size in centimeters, convert row heights from points directly: 15 points is about 0.53 cm. Column widths need an approximate conversion because Excel measures them using font-related character units; a common default column is about 1.7 cm on a 96-DPI screen. Use Page Layout rulers for page-based work, enter row and column settings through Home > Format, and check print scaling whenever physical output matters.

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.