activate the metric ruler
Past excel programs, I've spent hours formatting precise guidelines for my calligraphy students in millimeters. But under this new Excel, I've lost all of that work. It has shifted the file into some unnamed unit, even though I've changed it to millimeters in my Preferences. Very frustrated that my previous formatting has been lost.