You need to fit your Excel data onto a printed page without cutting off content. Manually entering margin numbers in the Page Setup dialog is often a guesswork process. Excel’s Print Preview includes a visual mode for adjusting margins directly on the page. This article explains how to use this interactive feature to align your printout perfectly.
Key Takeaways: Adjusting Margins in Print Preview
- File > Print > Show Margins: Toggles the interactive margin lines and handles on the print preview screen.
- Drag the margin lines: Click and drag the dotted lines to visually set the top, bottom, left, and right page margins.
- Drag the column width handles: Adjust the width of printed columns directly in the preview without returning to the main worksheet view.
Using the Visual Margin Adjustment Feature
Excel’s Print Preview is more than a static view of your page. When you enable the margin display, it becomes an interactive layout tool. This feature overlays dotted lines representing the current page margins. You can click and drag these lines to new positions, instantly changing the layout. This method is ideal for quickly fitting an extra row or column onto a page without using the Page Setup dialog.
Prerequisites for Visual Adjustment
Your worksheet must be in a state ready for printing. Ensure your data is within the print area. If you have set a specific print range, the preview will show only that range. The visual margin tool works with all standard page orientations and common paper sizes like Letter and A4. It is available in Excel for Microsoft 365, Excel 2021, Excel 2019, and Excel 2016.
Steps to Visually Adjust Print Margins
- Open the Print Preview pane
Go to File > Print. The main window changes to show a preview of your document on the right and print settings on the left. - Enable the margin view
At the bottom-right corner of the preview pane, click the Show Margins icon. It looks like a small page with dotted lines on its edges. Dotted lines will appear around your preview showing the current margin boundaries. - Adjust the page margins
Move your cursor over any dotted margin line. The pointer will change to a double-headed arrow. Click, hold, and drag the line inward to make a margin smaller or outward to make it larger. You can adjust the top, bottom, left, and right margins independently. - Adjust column widths (Optional)
With margins shown, black handles appear at the top of the preview over each column boundary. Drag these handles left or right to change the width of a column for the printout only. This does not change the column width in your actual worksheet. - Review and print
As you drag, the preview updates in real time. Check that all your data fits within the new margins. When satisfied, you can proceed to print directly from this pane by clicking the Print button.
Common Mistakes and Limitations
Margins Revert When Closing Preview
The margin changes you make visually are applied immediately to the worksheet. They do not revert when you close Print Preview. To confirm, go to Page Layout > Margins and you will see the new Custom Margins setting.
Cannot Drag Margins Beyond Page Limits
Excel will not let you drag a margin line to a position that makes the other margin too small. The minimum margin allowed is often determined by your printer driver. If you need margins smaller than the visual tool allows, you must use Page Layout > Margins > Custom Margins and enter specific values.
Show Margins Button is Grayed Out
This usually happens if no printer is selected or available. In the Print settings pane on the left, check that a printer is selected under the Printer dropdown. Selecting a printer like “Microsoft Print to PDF” will usually activate the button.
Manual vs Visual Margin Adjustment: Key Differences
| Item | Visual Adjustment in Print Preview | Manual Entry in Page Setup |
|---|---|---|
| Method | Click and drag dotted lines | Type numerical values into dialog boxes |
| Best For | Quick layout fitting and visual alignment | Precise, repeatable margin settings |
| Access Path | File > Print > Show Margins icon | Page Layout > Margins > Custom Margins |
| Real-time Preview | Yes, updates as you drag | No, must click OK to see changes |
| Adjust Column Widths | Yes, via handles in preview | No, must be done in worksheet view |
You can now use the Show Margins tool to arrange your printouts by sight. For precise control, remember the Custom Margins dialog is still available from the Page Layout tab. Try using the column width handles in the preview to fine-tune a table’s layout without affecting your working data.