Share via

How to set Excel to display eg Page margins in mm and not inches

Anonymous
2012-07-07T20:52:55+00:00

See header!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2012-07-07T20:58:40+00:00

By default, Excel will use the unit corresponding to your regional settings in Windows,

To choose another unit:

Select File > Options.

Click Advanced and scroll down to the Display section.

Select mm from the Ruler units dropdown and click OK.

Was this answer helpful?

10+ people found this answer helpful.
0 comments

Answer accepted by question author

Anonymous
2012-07-07T21:03:41+00:00

Hi,

File|Options|Advanced

In the 'Display' group change the ruler units to millimeters

Was this answer helpful?

10+ people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2012-07-07T21:45:04+00:00

    Windows offers a choice between metric units (cm) and imperial units (inch), not mm. So you have to set this in Excel itself.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-07-07T21:34:41+00:00

    I've done that with Excel but as a matter of interest, I cannot find any settings for millimetres as the default via regional settings

    Was this answer helpful?

    0 comments