Home  »  Excel   »   Set Units of Measurement to Inches or Centimeters in Excel 2013/2016

Set Units of Measurement to Inches or Centimeters in Excel 2013/2016

By | January 26, 2018

By default, Excel takes units of measurement from the system settings. Sometimes, however, these settings are not the ones we want to use in Excel. The good news is that these units can be changed in Excel settings without having to intervene in the system configuration. Here's how to do it.

  1. On the ribbon click File tab

    show-formula-bar-excel-main-window

    Click to enlarge

  2. On the left bottom, click Options

    show-formula-bar-excel-open

    Click to enlarge

  3. In Excel Options window go to Advanced options.
    There in Display section is a Ruler units drop down. Click it and choose the unit you want.

    change-units-excel-advanced-options

    Click to enlarge

Rating: 4.8. From 2 votes. Show votes.
Please wait...

Leave a Reply

Your email address will not be published.