Forum Discussion
andrew59715
Jan 20, 2025Copper Contributor
Print a booklet
I want to print a booklet of my excel pages.
To do this I would print 2 pages to a sheet, horizontal orientation.
It will be 12 pages, so on the first sheet of paper I want to print page 12 on the left side of the page, and page 1 on the right side of the page.
On the back of that sheet I want to print page 2, then 11.
On the second sheet I want to print page 10, and 3 on the front of the sheet; and page 4, and 9 on the back of the sheet.
Then I can collate them, fold them in half and staple the fold to product a 5 1/2 x 8 1/2 booklet.
Can I do this in excel? In other words, can I choose in what order the pages are printed?
- m_tarlerBronze Contributor
This is a feature built into some print drivers. After going into the print window, look for booklet option and if not you may need to try the advanced options. Here is an example from a printer:
Alternatively I would print to PDF and then use your PDF viewer to then print as a booklet: