Forum Discussion

Copper Contributor

Apr 24, 2022

More Excel weirdness-how do I reset columns in inches

This was so easy in Office 2013, but I can't seem to do it in 2021. Have set the File-Options-Advanced-Display-Ruler Units to inches, but everything still comes up pixels. What next?

excel

HansVogelaar

MVP

Apr 24, 2022

Lori_U

Switch to Page Layout view. You can then view and set column widths in inches.

Lori_U
Copper Contributor
Apr 24, 2022
Not working.
- HansVogelaar
  MVP
  Apr 24, 2022
  Lori_U
  
  Oh. Without further details I have no idea...
  - Lori_U
    Copper Contributor
    Apr 25, 2022
    Finally figured out I needed to be in View-Page Layout rather than in just Page Layout...working fine now. Thanks!