Forum Discussion

Copper Contributor

Jun 05, 2023

Solved

Excel Columns width and heights measured in pixels instead of inches

I want the Columns width and heights measured in inches instead of pixels. I have contacted Microsoft Support 3 times concerning this and even purchased an update to 2021 Office on 5/18/2023. I have ...

excel

Patrick2788
Jun 05, 2023
KimCCalvert
I believe this is for Page Layout view specifically.

From the support article:
If you are working in Page Layout view (View tab, Workbook Views group, Page Layout button), you can specify a column width or row height in inches, centimeters and millimeters. The measurement unit is in inches by default. Go to File > Options > Advanced > Display > select an option from the Ruler Units list. If you switch to Normal view, then column widths and row heights will be displayed in points.Change the column width and row height - Microsoft Support

Patrick2788

Silver Contributor

Jun 05, 2023

KimCCalvert

I believe this is for Page Layout view specifically.

From the support article:

If you are working in Page Layout view (View tab, Workbook Views group, Page Layout button), you can specify a column width or row height in inches, centimeters and millimeters. The measurement unit is in inches by default. Go to File > Options > Advanced > Display > select an option from the Ruler Units list. If you switch to Normal view, then column widths and row heights will be displayed in points.Change the column width and row height - Microsoft Support

KevinBD
Copper Contributor
Dec 10, 2023
Command does not exist to change display to inches

Patrick2788
- Patrick2788
  Silver Contributor
  Dec 10, 2023
  KevinBD
  Your screen capture is from Word.
  
  This is from Excel:
KimCCalvert
Copper Contributor
Jun 05, 2023
Patrick2788
Yeah, doesn't work in Normal View. Thanks