Excel normally measures column width in characters, not inches, which makes it hard to match a printed form or label sheet. The fix is Page Layout view: switch to it and the Column Width and Row Height boxes accept inches (or centimeters). Here’s how to set exact column widths and row heights in inches, change the ruler units, apply one width to many columns, and understand how Excel’s character units convert.
Before setting widths, you may want to insert a column in Excel where your table needs one.
If you do not need a physical measurement, it is quicker to make a cell longer in Excel by dragging the column edge or using AutoFit.

Set Column Width in Inches
- Click View > Page Layout, or the Page Layout icon at the bottom right of the window.
- Select the columns: click a column letter, or drag across several.
- Right-click a selected column letter and choose Column Width. (Or go to Home > Format > Column Width.)
- Type the width, for example 1.5 or 1.5″, and click OK.
- Switch back with View > Normal. The widths stay the same.
Why does my column show 1.49″ after I typed 1.5″?
Excel rounds widths to whole pixels, so the stored value can differ slightly.
Set Row Height in Inches
In Page Layout view, select the rows, right-click a row number, choose Row Height, and enter a value in inches. In Normal view, row height is measured in points (72 points = 1 inch).
Change the Ruler Units
- Go to File > Options > Advanced.
- Under Display, set Ruler units to Inches, Centimeters or Millimeters.
- Click OK. Page Layout view now uses those units.
The default setting follows your Windows region, which is why some people see centimeters.
The same Page Layout rulers help when you resize a picture to an exact number of inches to fit a column.
Drag to Resize With the Ruler
In Page Layout view, drag the border between column letters. Excel shows the width in inches as you drag, and the ruler above the page helps you line things up.
How Excel’s Normal Units Work
- Column width in Normal view is the number of characters of the default font’s digit that fit in the cell. The default is 8.43 characters (64 pixels at 100% scaling with the default font).
- Row height is in points; the default is 15 points (about 0.21 inches) with the default font.
- Because widths depend on the font and screen scaling, converting characters to inches is approximate. Page Layout view is the reliable way to get inch-accurate widths for printing.
Apply One Width to Many Columns or the Whole Sheet
- Click the Select All triangle at the top left of the grid, then set Column Width to resize every column.
- To change the default for new columns, use Home > Format > Default Width (in characters).
- Copy a column’s width to others with Paste Special > Column widths.
Excel for Mac and the Web
- Mac: choose View > Page Layout, then Format > Column > Width. Units follow Excel > Preferences > General > Ruler units.
- Web: Excel for the web has no Page Layout view, so widths are set in characters or pixels. Open the file in the desktop app for inch-accurate layouts.
Does this work in older versions like Excel 2013?
Yes. The steps are the same in Excel 2010 and later.
Printing Tips
- Check Page Layout > Margins so your columns fit the printable area.
- Use File > Print preview to confirm before printing on labels or forms.
- Printer driver scaling can shift sizes slightly; set Scaling to No Scaling for exact output.
To take a column out of view entirely, hide rows and columns in Excel.
To work in metric, switch the ruler to centimeters.
Once a column has a fixed width, long notes in it are easier to read when you wrap text onto multiple lines in Excel.

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.