How to Show the Ruler in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on May 28, 2023

This tutorial demonstrates how to show the ruler in Excel.


show the ruler in excel


The ruler can be a useful option in Excel, especially when you want to align your document for printing. In the Ribbon, go to View > Page Layout and make sure Ruler is checked.


ruler page layout


In the View tab, Normal view is selected by default with Ruler already checked. If not, check it.

When Ruler is checked, rulers will appear at the top and left sides of the sheet. This can help you align your data within the sheet.


ruler page layout 2


Change Excel’s Ruler Units

Excel’s ruler unit is set based on Windows default measurement system settings in Control Panel. If you want to change this unit, you need to change Excel settings.

1. First, open Excel and select Options at the end of the menu.


excel ruler unit


If you are already in Excel Workbook, in the Ribbon, select File > Options.

2. Now, select Advanced and go to the Display section. Here you can find the “Ruler units” drop-down menu. Choose Inches, Centimeters, or Millimeters and click OK.


ruler unit options

AI Formula Generator

Try for Free

See all How-To Articles