How to Change the Ruler from Inches to Centimeters in Excel 2013

Like the rest of the programs in the Microsoft Office suite, Excel uses a ruler that allows you to specify the size of margins. The default unit of measurement will vary depending upon your location, but for many people it is set to use inches. If you are not comfortable with inches as a unit of measurement, or if you prefer centimeters, however, you can adjust the settings in Excel 2013 to use that unit of measurement instead. Simply follow the steps below to learn how.


Change the Ruler’s Unit of Measurement in Excel 2013

Note that changing the default unit of measurement is also going to apply in some other locations as well, such as page size. It will not, however, convert any values that you enter into your cells.


Step 1: Launch Excel 2013.


Step 2: Click the File tab at the top-left corner of the window.

click the file tab



Step 3: Click Options at the bottom of the column on the left side of the window. This is going to open a new Excel Options window.

click options



Step 4: Click the Advanced tab at the left side of the Excel Options window.

click the advanced tab in the excel options window



Step 5: Scroll down to the Display section of the window, click the drop-down menu to the right of Ruler Units, and select the Centimeters option.

how to change the unit of measurement from inches to centimeters in excel 2013



Step 6: Click the OK button at the bottom of the window to apply your changes and close this window.


If you’re looking for an inexpensive device that allows you to watch Netflix, Hulu Plus, Amazon Prime and HBO Go on your TV, check out the Roku LT.

You can also learn how to change the default file format to .xls in Excel 2013 if you need to use that file format more often. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.