You need to align text and objects on a printed Excel sheet. The default view does not show the page margins or a ruler for measurement. Excel has a Page Layout view that includes on-screen rulers. This article explains how to enable the ruler and use it for accurate print setup.
Key Takeaways: Show and Use the Ruler in Excel
- View > Page Layout button: Switches the workbook view to show page margins, headers, and rulers.
- View > Show > Ruler checkbox: Toggles the horizontal and vertical rulers on and off within Page Layout view.
- File > Print > Page Setup > Margins tab: Lets you set exact margin measurements that the ruler visually represents.
Understanding Excel’s Page Layout View and Rulers
Excel’s Page Layout view is a WYSIWYG editing mode. It shows your worksheet as it will appear on a printed page. This view displays page margins, headers, footers, and the space between pages. The horizontal and vertical rulers are key tools in this view.
The rulers provide a visual guide in inches, centimeters, or millimeters. Their scale changes with your zoom level. They help you position shapes, text boxes, and cell content by showing distances from the page edge. You must be in Page Layout view to see or use the rulers. The ruler setting is saved per workbook and view.
Steps to Enable and Use the Ruler
Follow these steps to turn on the ruler and align your sheet for printing.
- Switch to Page Layout View
Open your workbook in Excel. Go to the View tab on the ribbon. In the Workbook Views group, click the Page Layout button. Your sheet will change to show gray page margins and a white page area. - Enable the Ruler Display
While still on the View tab, look at the Show group. Check the box next to Ruler. The horizontal ruler will appear above the column letters. The vertical ruler will appear to the left of the row numbers. - Adjust the Ruler Units
Go to File > Options. In the Excel Options dialog, select the Advanced category. Scroll down to the Display section. Find the Ruler units dropdown menu. You can choose Inches, Centimeters, or Millimeters. Click OK to apply the change. - Use the Ruler to Set Margins
In Page Layout view, point your mouse at the line between the gray margin and white page area on the ruler. The cursor changes to a double-headed arrow. Click and drag this line to adjust the margin visually. For precise numbers, use the Page Layout tab > Margins button > Custom Margins. - Align Objects Using the Ruler
Select a shape, image, or text box. As you move or resize it, watch the ruler. A marker on the ruler shows the object’s current position. Drag the object until the ruler marker aligns with your desired measurement.
Common Mistakes and Limitations
Ruler Checkbox is Grayed Out
The Ruler checkbox is only active in Page Layout view. If it is gray, you are in Normal or Page Break Preview view. First, click the Page Layout button on the View tab. The checkbox will then become available.
Ruler Does Not Show Correct Measurements
The ruler scale is tied to zoom. At 100% zoom, one inch on the ruler matches one physical inch. If you zoom out, the ruler units compress. For accurate alignment, set your zoom to 100% before taking measurements from the ruler.
Vertical Ruler is Missing
The vertical ruler may not appear if the worksheet is too wide for the window. Use the horizontal scroll bar to scroll all the way to the left. The vertical ruler is anchored to the left edge of the page. Also, ensure Show > Ruler is checked in the View tab.
Excel View Modes Comparison
| Item | Normal View | Page Layout View | Page Break Preview |
|---|---|---|---|
| Primary Use | General data entry and formula work | Preparing sheets for printing, aligning objects | Adjusting where pages break when printed |
| Shows Rulers | No | Yes | No |
| Shows Page Margins | No | Yes | As dashed blue lines |
| Shows Headers/Footers | No | Yes | No |
| Best for Measurement | Not applicable | Excellent for visual alignment | Not applicable |
You can now use the ruler in Page Layout view to position content for printing. Check the Ruler box in the View tab after switching to Page Layout. For exact control, combine the visual ruler with the Margins settings on the Page Layout tab. Use the F4 key to repeat your last action, like aligning another object to the same ruler position.