How to Add Ruler in Excel: Simple Click and Measure Method

I spent years working in Excel without realizing the ruler was missing from my view. The measurement tool hides in plain sight, waiting to be enabled with a single click.

This isn’t about complex formulas or macros. It’s a basic feature that makes formatting documents and aligning content foolproof. Works the same in Excel 2016 through 2021, with a slight menu variation in the newest versions.

You’ll gain precise control over column widths and row heights, eliminating the guesswork from document layout. The ruler appears above and beside your spreadsheet, giving instant visual feedback.

No special tools or add-ons required. Just a quick toggle in the view settings, and you’re measuring like a pro.

What Youll Need

Instructions

Here’s the simplest way I know to get this done without any complicated workarounds.

Start by launching Excel and opening your workbook. Click the View tab in the ribbon at the top of the window. In the Workbook Views group, select Page Layout. This switches your worksheet to a view that mimics how it will look when printed.

You’ll immediately notice the worksheet appears with page margins and a faint outline of where the page breaks occur. This is the first sign you’re on the right track.

Once in Page Layout view, look at the top and left edges of the worksheet. The horizontal and vertical rulers should appear by default. If they don’t, click the File tab, then Options, followed by Advanced.

Scroll down to the Display section and ensure the box for Show ruler is checked. Click OK to confirm. The rulers will now be visible along the top and left side of the worksheet, measured in inches.

By default, the ruler uses inches, but you can change it to centimeters or millimeters. Go back to File > Options > Advanced. Under the Display section, find the Ruler units dropdown and select your preferred unit of measurement.

Click OK to save. The ruler updates instantly, so you’ll see the new units reflected right away without needing to restart Excel.

The ruler helps you measure column widths and row heights accurately. Hover your cursor over the boundary between two column headers or row numbers until it turns into a double-headed arrow. Drag to resize while watching the ruler to hit your exact measurement.

For example, if you need a column to be exactly 2 inches wide, drag the boundary until the ruler shows the correct width. Release the mouse, and the column will resize to that dimension.

Once you’ve made your adjustments, switch back to Normal view for regular editing. Click the View tab again and select Normal from the Workbook Views group. The rulers will disappear, but your column and row measurements remain unchanged.

This keeps your workspace clean while preserving the precise layout you’ve set. The ruler will reappear the next time you switch to Page Layout view.

Tips and Common Mistakes

These small adjustments will make your Excel ruler experience much smoother and more accurate.

View Selection Tip: In Step 1, don’t skip the Page Layout view—this is what triggers the ruler to appear. I’ve seen users try to enable rulers in Normal view and wonder why they don’t show up. The view change is essential for the ruler functionality to activate.

Display Settings Check: For Step 2, if rulers aren’t visible after switching to Page Layout, double-check the Show ruler box in Advanced options. I’ve found this setting sometimes resets after Excel updates, so it’s worth verifying even if you’re sure it was enabled before.

Unit Conversion Trick: When changing ruler units in Step 3, remember the conversion happens instantly without restarting Excel. This is particularly helpful when working with international templates that use different measurement systems.

Precision Technique: In Step 4, when dragging column boundaries, use the ruler as your guide rather than guessing. That 2-inch measurement mentioned in the example is exact—trust the ruler more than your eyes for perfect sizing every time.

Frequently Asked Questions

Adding a ruler in Excel is a breeze once you know where to look! 🌟 Whether you’re aligning data or measuring column widths, this feature ensures precision. Now that you’ve mastered it, try exploring Excel’s other formatting tools to enhance your spreadsheets further. Happy organizing!