How to print parity pages in Excel

Printing parity pages in Excel will not be as simple as printing parity in Word because it does not have Odd Pages or Even Pages functionality . So to make a parity page print in Excel, we need to follow a different method.

How to print parity pages in Excel Picture 1

Before you can even print odd pages in Excel, you need to check the page numbering of the data.

To do this, open the Page Layout ribbon and then click on the expanded icon of the Page Setup section to access more functions in this section.

How to print parity pages in Excel Picture 2

When the Page Setup dialog box dialog box opens, switch to the Sheet tab .

In the Page order section , you will notice there are two options:

- Down, then over : The priority order from top to bottom then from left to right.

- Over, then down : The priority order from left to right and then from top to bottom.

With the figure next to it, you will probably quickly figure out how to paginate the page from there.

How to print parity pages in Excel Picture 3

Next to start printing the parity in Excel you on the ribbon File and select Save As or use the key combination Ctrl + Shift + S .

How to print parity pages in Excel Picture 4

You change Save as type to PDF (* .pdf) so that you can save your Excel file as a PDF file. Click Save to save the file.

How to print parity pages in Excel Picture 5

After saving the Excel file as a PDF file, open the PDF file. If your computer has PDF readers available, the better it will be, the easier it will be to read and print. If not, you can download free PDF readers like Foxit Reader, PDFcreator, Adobe Reader, SumatraPDF .

How to print parity pages in Excel Picture 6

After opening the saved PDF file, you can check your text as a page after printing is always in the main interface of the PDF reader software.

Then you go to the File ribbon on the toolbar.

How to print parity pages in Excel Picture 7

Click on the Print line to open the print interface of the PDF software.

Or you can also use the key combination Ctrl + P to do the same thing.

How to print parity pages in Excel Picture 8

With the Print interface, in addition to other settings related to printing, you need to pay attention to the Subset function . This is the odd page even setting that we need.

The Subset function always leaves the default as All page in range which means printing all the pages in the file.

When you change it to Odd pages only , the software will print only odd pages of data.

How to print parity pages in Excel Picture 9

And change it to Even pages only , the software will only print even pages in your dataset.

How to print parity pages in Excel Picture 10

Then click OK or Print with some other PDF software to print. The result you get will be exactly what you installed.

Thank you for reading our article TipsMake.Vn on how to print parity pages in Excel. Wish you can successfully implement this trick after reading all the instructions above.