How to Get the Ruler to Show Up in MS Excel

Written by amanda rumble
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Get the Ruler to Show Up in MS Excel
Show a ruler on your Excel workbook for an accurate size representation. (Jupiterimages/Comstock/Getty Images)

Microsoft Office Excel allows you to show rulers, both horizontal and vertical, on the page so that you can measure how much space each column, row, graph or chart takes up on the page. This is ideal to know before printing, as you can then modify the document to fit on the page as necessary. Excel allows you to customise the units of measurement from your operating system's default to inches, centimetres or millimetres. By default, these rulers are not shown on-screen. You can enable them to use in your current workbook.

Skill level:


  1. 1

    Open "Microsoft Excel."

  2. 2

    Select the "View" tab.

  3. 3

    Click "Page Layout," located in the "Workbook Views" section.

  4. 4

    Change your measurement options by clicking the "Microsoft Office" button. Select "Excel Options" and choose "Advanced."

  5. 5

    Click the units to use from the "Ruler Units" box located under "Display."

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.