Formatting Issues

How to Set Exact Column Widths and Row Heights in Excel

Jason Miller Oct 23, 2026 869 views

Question details

The user needs to set exact physical measurements for column widths and row heights in Excel and wants to understand why the numbers change across different views.

How to Set Exact Column Widths and Row Heights in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Formatting a spreadsheet to exact physical dimensions (e.g., inches or centimeters) for precise layout or printing.
Observed behavior: Excel displays different row and column measurement units in Page Layout view compared to Normal view, causing values to appear incorrect or smaller after switching views.

Before you start

Verify that your computer's display resolution is set to the system's recommended scale, as custom DPI settings can slightly alter how physical dimensions render on screen.

Solution 1Recommended

Set Exact Dimensions using Page Layout View

Switch to Page Layout view to input exact physical measurements in inches or centimeters, bypassing standard character units.

In Normal view, Excel measures column width by the number of default font characters that can fit in a cell, and row height in points. To set dimensions using physical measurements like inches or centimeters, you must use Page Layout view.

Switch to Page Layout View

Navigate to the 'View' tab on the top ribbon and click on 'Page Layout' in the Workbook Views group.

Select Target Columns or Rows

Click on the column headers (letters at the top) or row headers (numbers on the left) that you want to adjust.

Open the Dimension Dialog

Right-click the selected header and choose 'Column Width' or 'Row Height' from the context menu.

Apply Exact Measurements

Type the exact dimension you need into the dialog box and click 'OK'.

Set Exact Dimensions using Page Layout View

Measurement Changes Between Views: When you switch back to Normal view, Excel converts these physical dimensions back to character units and points. Your exact dimensions are still preserved for printing; they simply display in a different unit format in Normal view.

Precise Spreadsheet Formatting

Easily Set Exact Row and Column Sizes with WPS Spreadsheet

WPS Spreadsheet provides a highly intuitive interface for adjusting exact column widths and row heights, ensuring your documents are printed with perfect precision while remaining fully compatible with Excel formats.

1. Open Your Spreadsheet: Launch WPS Office and open your existing spreadsheet document.
2. Switch to Page Layout: Go to the 'View' tab and click on the 'Page Layout' icon.
3. Enter Exact Sizes: Right-click the specific row or column headers, select the height/width option, and type your exact dimension.

Fully compatible with Microsoft Excel (.xlsx, .xls) files and formattingEasy-to-use Page Layout view for accurate physical printing measurementsLightweight, fast, and completely free to use without mandatory subscriptions

microsoft office alternative - wps office

Frequently Asked Questions

Why does my column width change when I switch back to Normal view in Excel?

Normal view measures column widths in character units (based on the default font) and row heights in points, whereas Page Layout view uses absolute units like inches or centimeters. The actual physical size on the printed page remains the same, but the unit of measurement displayed changes.

How can I change the default measurement units in Excel?

You can change the default ruler units by going to File > Options > Advanced. Scroll down to the 'Display' section and select your preferred unit (Inches, Centimeters, or Millimeters) from the 'Ruler units' drop-down menu.

Can I set exact measurements in pixels instead of inches?

Yes, while in Normal view, you can click and drag the boundary of a column or row header. A tooltip will display the size in both points/characters and pixels. Alternatively, web-oriented projects often rely on pixels directly through exact row height adjustments.

Document & File Issues