Excel Change Cell Size to Inches, cm, mm?

Yes, you can change Excel’s row height and column width to display in inches, centimeters, or millimeters, but not directly. Excel’s built-in ruler and page layout view show measurements in inches, while the row height and column width dialog boxes use points and character units. This article explains the exact steps to work in physical units, how to convert between them, and the limitations you’ll encounter.

Formula

Excel’s row height is measured in points (1 point = 1/72 inch). Column width is measured in characters (the width of the default font’s “0� digit), which varies by font and size. To convert between centimeters and points, use:

• 1 inch = 2.54 cm = 72 points
• 1 cm = 28.3465 points
• 1 cm ≈ 37.795 pixels (at 96 DPI, the standard Windows display)

For column width, there is no universal formula because the character unit depends on the font. A common approximation for the default Calibri 11 font is: 1 character ≈ 7 pixels, so 1 cm ≈ 5.4 characters. For precise work, use the Page Layout view.

Worked Example

Suppose you want a cell to be exactly 2.54 cm (1 inch) tall. In the default view, row height is in points:

1. Select the row(s).
2. Right-click and choose Row Height.
3. Enter 72 (since 2.54 cm = 1 inch = 72 points).

For a column width of 2.54 cm, switch to Page Layout view (View tab > Workbook Views > Page Layout). Now the column width and row height rulers are shown in inches by default. Right-click the column, choose Column Width, and enter 1 (inch). Alternatively, use the ruler to drag to the exact size. To use centimeters or millimeters, change the display unit in File > Options > Advanced > Display > Ruler Units.

Why Excel Doesn’t Have a Direct “cm� Setting

Excel was designed as a spreadsheet for calculations, not as a page-layout tool. Row height and column width are stored in abstract units that depend on the display resolution and font. This allows the grid to scale when you zoom, but it makes physical measurements ambiguous. The Page Layout view was added to bridge this gap, letting you see and adjust dimensions in real-world units for printing.

How to Change Ruler Units to cm or mm

To set the ruler to centimeters or millimeters:

1. Go to File > Options > Advanced.
2. Scroll to the Display section.
3. Under Ruler Units, choose Inches, Centimeters, or Millimeters.
4. Click OK, then switch to Page Layout view.

This affects only the rulers and the dialog boxes in Page Layout view. The normal view still uses points and characters.

Common Problems and Misconceptions

One common mistake is assuming that the “Column Width� number equals centimeters. It does not. A column width of 10 means 10 characters of the default font, not 10 cm. Similarly, row height of 15 is 15 points, not 15 pixels. Another issue is that changing the zoom level does not change the actual size, but it can make the on-screen ruler appear incorrect. Also, the ruler units setting applies to the entire workbook, not individual sheets. If you need precise millimeter measurements, always use Page Layout view and set the ruler to millimeters.

Alternatives for Precise Physical Sizing

If you need exact dimensions for labels, cards, or print layouts, consider these options:

• Use Page Layout view with ruler units set to inches/cm/mm.
• Insert a Shape (Insert > Shapes > Rectangle) and set its height and width in the Size group – these accept inches and can be converted.
• Use a Table with fixed column widths and row heights, then print to PDF to verify.
• For complex layouts, use Word or a dedicated design tool, then copy the content back as an image.

Frequently Asked Questions

How do I set row height to exactly 1 cm in Excel?

Go to Page Layout view, make sure the ruler is set to centimeters (File > Options > Advanced > Display > Ruler Units). Right-click the row header, choose Row Height, and enter 1. If you’re in the normal view, enter 28.35 (points) because 1 cm = 28.3465 points.

Why is my column width number not in inches?

Because Excel’s default column width unit is the “character� – the width of the digit ‘0’ in the default font. This is an abstract unit that does not correspond to a physical measure. To see inches, switch to Page Layout view; the column width dialog will then show inches (or cm/mm if you changed the ruler units).

Can I change the default unit for all new workbooks?

Yes, the ruler unit setting (File > Options > Advanced > Display > Ruler Units) is a global Excel option. It applies to all workbooks you open on that computer. However, it only affects Page Layout view; the normal view still uses points and characters.

Does changing zoom affect the actual cell size?

No, zoom only changes the on-screen magnification. The actual row height and column width remain the same. If you print, the physical size is determined by the values in points/characters, not by the zoom level.

How many pixels is 1 cm in Excel?

At the standard 96 DPI (dots per inch) display, 1 cm is approximately 37.795 pixels. This is useful when you need to match an image or a web layout. However, Excel does not expose pixel dimensions directly; you can calculate it using the conversion factor.

Is there a way to lock cell sizes to prevent changes?

Yes, you can protect the worksheet. Select the cells you want to allow editing, right-click > Format Cells > Protection and uncheck “Locked�. Then go to Review > Protect Sheet and set a password. This prevents users from resizing rows or columns unless you allow it in the protection options.

Related

• Micro LED Vertical Stacking: Key Facts
• Large Screen Android One Handed: Tips & Modes
• 8K Polling Rate: Does It Improve Gaming Performance?

in cm | Cell size in cm | cm | 2.54 | 0
out px | Approximate pixels | px | cm * 37.795 | 0
out pt | Points (Excel row height) | pt | cm * 28.3465 | 1
out in | Inches | in | cm / 2.54 | 2