How to Set Excel Column Width in Inches

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). This guide shows 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.

Quick Answer

Go to View > Page Layout, select the columns, right-click a column header, choose Column Width, type a value such as 1.5, and click OK. In Page Layout view, the value is in inches.

Set Column Width in Inches

1. Click View > Page Layout, or the Page Layout icon at the bottom right of the window.
2. Select the columns: click a column letter, or drag across several.
3. Right-click a selected column letter and choose Column Width. (Or go to Home > Format > Column Width.)
4. Type the width, for example 1.5 or 1.5″, and click OK.
5. Switch back with View > Normal. The widths stay the same.

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

1. Go to File > Options > Advanced.
2. Under Display, set Ruler units to Inches, Centimeters or Millimeters.
3. Click OK. Page Layout view now uses those units.

The default setting follows your Windows region, which is why some people see centimeters.

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.

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.

Frequently Asked Questions

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.

Can I use centimeters?

Yes. Change Ruler units to Centimeters in Excel Options, then set widths in Page Layout view.

Does this work in older versions like Excel 2013?

Yes. The steps are the same in Excel 2010 and later.

Summary

1. Switch to View > Page Layout.
2. Right-click column headers > Column Width, and type inches.
3. Set row heights the same way.
4. Change units in File > Options > Advanced > Ruler units.