Printing Problems

How to Set Different Margins for Odd and Even Pages in Excel

Maira Mehtab Sep 22, 2026 868 views

Question details

The user wants to know if it is possible to configure different page margins for odd-numbered and even-numbered pages for printing purposes.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Formatting a worksheet for double-sided printing or document binding.
Observed behavior: Excel does not offer a built-in feature to set alternating page margins (mirror margins) natively within its page layout settings.

Before you start

Before adjusting your page layout, determine if your final document will be bound; if binding is required, you may need to use a word processor to achieve the necessary 'mirror margins'.

Solution 1Recommended

Workaround: Copy Data to a Word Processor for Mirror Margins

Since Excel does not natively support different margins for odd and even pages, copying your data to Microsoft Word or WPS Writer allows you to use built-in 'Mirror Margins'.

Word processors are designed for book-style formatting and include specific features for binding double-sided documents. Moving your spreadsheet data into a document is the most reliable way to achieve this layout.

Copy Excel Data

Open your Excel worksheet, highlight the data you want to print, and press Ctrl + C to copy it.

Paste into a Document

Open a blank document in Word or WPS Writer and press Ctrl + V to paste your data.

Access Page Layout

Navigate to the 'Layout' or 'Page Layout' tab on the top ribbon.

Apply Mirror Margins

Click on 'Margins', select 'Custom Margins', and under the 'Multiple pages' dropdown, choose 'Mirror margins'. Adjust the inside and outside margin sizes as needed for your binding.

Formatting Adjustment: You may need to adjust the column widths or change the page orientation to Landscape in the word processor to ensure your table fits correctly.

Solution 2

Apply Uniform Wide Margins in Excel

If you prefer to print directly from Excel without exporting, you can apply a single set of symmetrically wide margins to accommodate binding on both sides.

Free Microsoft Office alternative

Format and Print Bound Documents Easily with WPS Office

While Excel lacks advanced book-style printing features like mirror margins, WPS Office provides an all-in-one suite. You can effortlessly switch your spreadsheets into WPS Writer to apply professional, double-sided print settings—including different margins for odd and even pages—without losing your table formatting.

1. Download WPS Office: Install WPS Office for free from the official website.
2. Open Your Spreadsheet: Launch WPS Spreadsheets to view and select your tabular data.
3. Transfer to Writer: Copy the data into WPS Writer to access advanced page layout features like Mirror Margins.

Highly compatible with Microsoft Excel (.xlsx) and Word (.docx) formats.Seamlessly copy spreadsheet data into WPS Writer to utilize 'Mirror Margins' for binding.Lightweight, fast, and completely free to use for daily office tasks.All-in-one tabbed interface allows you to manage spreadsheets and text documents in one window.

Frequently Asked Questions

What are mirror margins?

Mirror margins are a layout setting used for double-sided documents (like books or bound reports). They ensure that the inside margins (near the binding) and the outside margins are identical across facing pages, which means odd and even pages have mirrored margin widths.

Can I print double-sided directly in Excel?

Yes, you can print double-sided in Excel. Go to File > Print, and under the settings dropdown that usually says 'Print One Sided', select 'Print on Both Sides'. However, this does not allow you to set different margin widths for the front and back of the pages.

Is there an Excel add-in to create different margins for odd and even pages?

Currently, there are no widely used standard add-ins that bypass Excel's core page layout limitations regarding odd and even margins. The most efficient and reliable method remains exporting the data to a dedicated word processing program.

Document & File Issues