How to Print Only Odd-Numbered Pages in Excel
Question details
The user needs a method to print only the odd-numbered pages of an Excel worksheet.

- 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 begin printing, ensure your worksheet's print area is properly set and verify the total number of pages using the Print Preview feature.
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.
Navigate to the 'File' tab in the top ribbon and select 'Print', or simply press Ctrl + P on your keyboard.
In the Settings section of the print dialog, find the 'Pages' input box where you can specify a custom print range.
Type the odd page numbers separated by commas (for example: 1, 3, 5, 7) into the input box, select your printer, and click 'Print'.

Automate Printing Odd Pages Using a VBA Macro
For larger worksheets or repeated tasks, a VBA macro can automatically loop through and print only the odd-numbered pages.
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. Open your Spreadsheet in WPS: Launch WPS Office and open your .xlsx workbook in WPS Spreadsheet.
- 2. Export to PDF: Go to the 'Menu' button, select 'Export to PDF', and save the document to your computer.
- 3. Open in WPS PDF: Open the newly created PDF file using the built-in WPS PDF tool.
- 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'.

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.




