Printing Problems

How to Print Only Odd-Numbered Pages in Excel

Steven ParkerSteven Parker Nov 11, 2026 870 views

Question details

The user needs a method to print only the odd-numbered pages of an Excel worksheet.

How to Print Only Odd-Numbered Pages in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Printing specific alternating pages of a multi-page spreadsheet.
Observed behavior
Excel does not offer a standard built-in setting or checkbox to print only odd pages, unlike Microsoft Word.
Before you start

Before you begin printing, ensure your worksheet's print area is properly set and verify the total number of pages using the Print Preview feature.

Solution 1Recommended

Manually Enter Odd Page Numbers in Print Settings

The most straightforward method for worksheets with a small number of pages is to manually specify the odd pages in the print dialog.

1
Open Print Preview

Navigate to the 'File' tab in the top ribbon and select 'Print', or simply press Ctrl + P on your keyboard.

2
Locate Page Settings

In the Settings section of the print dialog, find the 'Pages' input box where you can specify a custom print range.

3
Specify Odd Pages

Type the odd page numbers separated by commas (for example: 1, 3, 5, 7) into the input box, select your printer, and click 'Print'.

Manually Enter Odd Page Numbers in Print Settings
Efficient Printing with WPS Office

Easily Print Odd Pages Using WPS Spreadsheet and PDF

While spreadsheet software typically lacks an odd-page print toggle, WPS Office offers an elegant workaround: seamlessly export your workbook to a PDF natively, then use the built-in 'Print Odd Pages' feature in WPS PDF.

  1. 1. Open your Spreadsheet in WPS: Launch WPS Office and open your .xlsx workbook in WPS Spreadsheet.
  2. 2. Export to PDF: Go to the 'Menu' button, select 'Export to PDF', and save the document to your computer.
  3. 3. Open in WPS PDF: Open the newly created PDF file using the built-in WPS PDF tool.
  4. 4. Print Odd Pages: Press 'Ctrl + P' to open the print dialog. Look for the 'Subset' dropdown menu, select 'Odd pages only', and click 'Print'.
Seamlessly export Excel files to PDF natively in one clickBuilt-in PDF reader includes advanced 'Print Odd/Even Pages' functionalityFully compatible with Microsoft Excel (.xlsx) formatsLightweight, fast, and completely free to use
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Excel have an 'Odd/Even Pages' print option like Word?

Unlike Word, which is a word processor with fixed pagination, Excel is a dynamic grid. Page counts and boundaries constantly shift based on scaling, column widths, and print areas, making a native odd/even print toggle much more complex to implement.

Can I print odd pages by first saving the Excel file as a PDF?

Yes, exporting your Excel worksheet as a PDF is an excellent and highly recommended workaround. PDF readers natively include the option to filter and print only odd or even pages in their standard print dialogue boxes.

Is it possible to print even pages using the same VBA method?

Absolutely. By modifying the VBA loop to start at page 2 instead of page 1 (for example, changing the code to 'For i = 2 To TotalPages Step 2'), the macro will skip the first page and print only the even-numbered pages.