Printing a List into Multiple Columns to Fit on Each Printed Page in Excel!!
Tags: kutoolsexceltutorial, printingalistintomul, kutools
Published: 2020-10-09 12:09:24

---
title: Printing a List into Multiple Columns to Fit on Each Printed Page in Excel!!
published: true
date: 2020-10-09 07:03:09 UTC
tags: KutoolsExcelTutorial,Printingalistintomul,Kutools
canonical_url: https://geekexcel.com/printing-a-list-into-multiple-columns-to-fit-on-each-printed-page-in-excel/
---

In this post, we will describe the steps for **Printing a List into Multiple Columns to Fit on Each Printed Page** in **Excel Office 365** using **Kutools. ** Let’s get into this article!! 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.
## Split Long Column into Multiple Columns to Fit on One Printed Page:

To split the long column into multiple columns using Kutools, do as below steps.

- First, you need to **activate the worksheet** from which you want to split a long column into multiple columns.
- Go to the **Kutools Plus Tab, select** the **Split to Columns** option.

![Select the Split to Columns option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Split-to-Columns-option.png)<figcaption id="caption-attachment-15493">Select the Split to Columns option</figcaption>

- It will open the **Split to Columns Dialog Box**.
- **Titles range** – You need to **select the titles range** using the given browse button.
- **Data range** – Select the data list using the given browse button.
- **Rows per printed page** – In this box, you need to specify how many rows you want to print on each page.
- **Number of Segments** – You need to choose how many segments you want to display on each printed page.
- You need to **check** the **Create a link with the active sheet option**.
- **Hit** the **OK** button.

![Split to Columns Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Split-to-Columns-Dialog-Box.png)<figcaption id="caption-attachment-15494">Split to Columns Dialog Box</figcaption>

- Now, you can get the result in the new worksheet as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-20.png)<figcaption id="caption-attachment-15496">Output</figcaption>

## Closure:

From this post, you can clearly learn the steps for **Printing a List into Multiple Columns to Fit on Each Printed Page** in **Excel Office 365** using **Kutools.** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [Select All Unlocked Cells in Excel](https://geekexcel.com/how-to-select-all-unlocked-cells-in-excel-office-365-with-example/)
- [Remove All HTML Objects in Excel](https://geekexcel.com/how-to-remove-all-html-objects-in-excel-office-365-kutools/)