Printing multiple pages in a single worksheet in the same orientation

I have a worksheet containing about 1500 rows which I want to print in book form (so I can staple the pages together and read them like a book). Unfortunately when I print the worksheet on my duplex printer every second page is upside down. I don't know if the solution lies with the printer or within Excel. Is there any way within Excel that I can make the pages print the same way up on each side of a sheet of paper?

Hi

That is usually an option of the duplex printers.

You are printing on both sides of the paper.

1 - You may want to staple the pages in the long side and then turn the pages like in a book.

2 - You may want to staple the pages in the short side and then you have like a vertical notepad. In that case you want each second page to be printed upside down because you are flipping the pages vertically.

This is usually an option of the printer.

In File->Printer click on Printer Properties and check the options specific to the printer.

Make sure you have the correct printer driver installed.