Note: In Microsoft Excel 2007, OK is clicked twice – once from the Preferences window, and then from the Page Setup window.Ĭlick on Next Page and select Page Setup > Options again and set N-Up # of pages. (See Image 2.)Ĭlick OK until you get back to the Print Preview window. Note: You also have the option to Print Page Borders. In the Print Driver Preferences window, select Multiple pages per side ( N-Up) and set the # of pages i.e., 2, 4, 6, 9, and 16. Note: This will open the Print Driver Preferences window. Select File > Print > select Entire Workbook. Right-click on one of the sheets > Select All Sheets. Method 1: Manually setting N-Up and the number of pages for each page There are two ways that this can be done. You can specify the direction of the multiple images, how many can fit on the page depending on the available driver options, and whether the images are separated by a border. The N-Up Function is a printing option that allows you to print multiple pages’ content into one page.
