How to Get the Ruler to Show Up in MS Excel

Updated March 23, 2017

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."

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Amanda Rumble has been writing for online publications since 2000, primarily in the fields of computing and technology. She holds a bachelor's degree from the University of Buffalo in information technology. Rumble also focuses on writing articles involving popular video games and Internet culture.