• Skip to main content
  • Skip to primary sidebar

Excel Tips and Tricks

  • About
  • Privacy Policy

default units

How to change default ruler units in Excel

October 19, 2015 by Ravi 1 Comment

The default ruler units in Excel 2016, 2013 and Excel 2010 is set to Centimetres and users can change this default units using the Settings available as part of the Excel options.

View Ruler in Excel 2013

The Page Layout view will be display the ruler in Excel. And in case if the ruler is not displayed then make sure to mark the checkbox with label as Ruler.

image

Change ruler units in Excel

Step 1: Click the File menu and select Options from menu list.

Step 2: In the Excel options window, click Advanced tab and navigate to Display section.

image

Step 3: In the Display section, click the Ruler units drop down and select your preferred unit.

image

Step 4: Click Ok button to apply and save the changes.

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: Change, default units, Excel 2013, Ruler units, View Ruler

Primary Sidebar

Recent Posts

  • How to increase number of worksheets Excel
  • A trick to flip a column upside down in Excel
  • Prevent users from adding new worksheet in Excel
  • Repeat action keyboard shortcut in Microsoft Office
  • How to import text file in Excel

Copyright 2020 © getexceltips.com