Excel 2007 - I want the default unit to be mm, not cm

R

RetroMIDI

I want to set up Excel so that the units throughout are millimetres.
How can i do this/
 
B

Bernard Liengme

Not sure about "throughout" but:
Office icon (pretty circle top left); Excel Options (at bottom);
Advance (midway down left)
Look for Ruler and set to millimetres
Click OK at bottom
Now the ruler (when used) and Margins in Page Setup show metric units

Column width and row height are always in their own units.
best wishes
 
Top