More Excel weirdness-how do I reset columns in inches

Copper Contributor

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?

 

4 Replies

@Lori_U 

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

S1342.png

@Lori_U 

Oh. Without further details I have no idea...

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