How to Get the Ruler to Show Up in MS Excel

Written by amanda rumble | 13/05/2017
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.

Open "Microsoft Excel."

Select the "View" tab.

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

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

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

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