More Excel weirdness-how do I reset columns in inches

Question

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?&nbsp;

hansvogelaar · Answer

Lori_U&nbsp;
Switch to Page Layout view. You can then view and set column widths in inches.

lori_u · Answer

Not working.

hansvogelaar · Answer

Lori_U&nbsp;
Oh. Without further details I have no idea...

lori_u · Answer

Finally figured out I needed to be in View-Page Layout rather than in just Page Layout...working fine now. Thanks!

Forum Discussion

More Excel weirdness-how do I reset columns in inches

4 Replies

Resources