Print multiple ranges /selections into one page in Excel 2007 and 2010

Normally, when you are going to print multiple ranges or selections, Excel inserts a page break between each range that will cause a lot print waste. But Kutools for Excel’s Print Multiple Selection Wizard lets you print non-contiguous ranges without a page break, and you can also adjust the order of the selected ranges.

Usage:

Step 1：Before activating the function, hold down the “Ctrl” key to select the multiple ranges you want to print. This step is optional.

Step 2：Click Kutools for Excel >> Printing >> Print Multiple Selections Wizard. See screenshot (Fig. 1).

Fig. 1 Print Multiple Selections

Step 3：You can use the button to add more ranges to the list, while the button will remove the ranges you don’t want. The UP and Down arrow buttons help to rearrange the order of the selected range. Click “Next” to continue. See screenshot (Fig. 2).

Fig. 2 Select multiple ranges

Step 4：All the selections will be added to a new worksheet as a linked picture objects. In this step, you need to specify the printing settings. Click “Next” to continue. See screenshot (Fig. 3).

Tips:

• If you choose to specify new print settings, you need to click the Page Setup button to start the favotite page settings.
• If you select the Add a blank row between ranges option, the linked picture objects will have a space equal to one row height.

Fig. 3 specify the printing settings

Step 5：Specify the action for the temporary worksheet, and click “Finish”. See screenshot (Fig. 4).

Fig. 4 Actions for the temporary new worksheet

This is only one feature of Kutools for Excel

It includes more than 100 functions and tools for Excel 2007 and 2010.