How to Print Multiple Ranges/Selections into One Page in Excel 365?
Tags: kutoolsexceltutorial, printmultipleranges, kutools
Published: 2020-11-21 08:00:51

---
title: How to Print Multiple Ranges/Selections into One Page in Excel 365?
published: true
date: 2020-11-21 07:19:31 UTC
tags: KutoolsExcelTutorial,PrintMultipleRanges,Kutools
canonical_url: https://geekexcel.com/how-to-print-multiple-ranges-selections-into-one-page-in-excel-365/
---

In this tutorial, you will understand the steps to **Print Multiple Ranges/Selections into One Page in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Print Multiple Selections in Excel:

To print multiple ranges or selections into one page in Excel, kindly follow the below steps.

- Go to the **Kutools Plus Tab, select** the **Printing** option, then **choose** the **Print Multiple Selections Wizard** option.

![Kutools Plus Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-36.png)<figcaption id="caption-attachment-17803">Kutools Plus Tab</figcaption>

- It will display the **Print Multiple Selection Wizard Dialog Box**.
- You need to **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/shot-print-multiple-ranges-3.png) **button** to add the ranges to the list that you want to print.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/shot-print-multiple-ranges-4.png) **button** will be used to remove the range.
- **Up** and **Down arrow buttons –** These buttons are used to rearrange the order of the selected range.
- Then, **click** the **Next** option to continue this process.

![Click the Next button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-35.png)<figcaption id="caption-attachment-17806">Click the Next button</figcaption>

- It will open the next wizard.
- You need to **select** the **Specify new print settings** option under the **Print settings** section.

- **Use default print settings –** If you check this option, the page setup of the multiple selections will be the same as default print settings.
- **Use the print settings from the current worksheet –**  The page setup of the multiple selections will be the same as the current active worksheet.
- **Specify new print settings –** if you want some new page setup, you can check this option, and then **click** the **Page Setup**  button to set the **page settings** you like.

- Then, you need to choose the **Add a blank row between ranges** option.
- After that, **click** the **Next** button to go to the next process.

![click the Next button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-34.png)<figcaption id="caption-attachment-17807">Click the Next button</figcaption>

- It will open the  **Print Multiple Selection Wizard**.
- You need to select the **Activate the worksheet, but don’t print it** option under the **Action for the temporary worksheet** section.
- Then, you need to **click** the **Finish** button.

![Click the Finish button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-30.png)<figcaption id="caption-attachment-17808">Click the Finish button</figcaption>

- Finally, all the ranges you selected have been pasted into the new worksheet and you can re-arrange them in the worksheet.
- Refer to the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-25.png)<figcaption id="caption-attachment-17809">Result</figcaption>

## Conclusion:

In this tutorial, you can easily understand the steps to **Print Multiple Ranges/Selections into One Page in Excel Office 365** using **Kutools. ** Kindly, share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Convert Numbers to Ordinal Numeral in Excel Office 365!!](https://geekexcel.com/convert-numbers-to-ordinal-numeral-in-excel-office-365/)
- [Count the Occurrences of a Character in a String in Excel Office 365!!](https://geekexcel.com/count-the-occurrences-of-a-character-in-a-string-in-excel-office-365/)