Printing a list into multiple columns to fit on each printed page in Excel

Supposing there is a worksheet with more than 200 names in column A, and if you want to print this worksheet, it will consume quite a few pages. How could you reformat such a long column into multiple columns to fit on one printed page before printing it? Kutools for Excel’s Split to Columns utility can help you split / reformat long column into multiple columns to fit on one printed page quickly, and save your printer ink and paper when you need to print such a long column in Excel.

Split / reformat long column into multiple columns to fit on one printed page for printing

Click Kutools Plus >> Split to Columns. See screenshots:

Split / reformat long column into multiple columns to fit on one printed page for printing

1. Apply the utility (Click Kutools Plus > Split to Columns), and select the Data range and Titles range as follows. See screenshot:

2. Specify other setting as follows. See screenshot:

A: Please specify how many rows you want to display on each printed page. B: Please specify how many segments you want to display on each printed page. C: It will create a link to the original sheet. Note: this utility will reformat / split the long column into multiple columns in a new worksheet.

3. Click Ok. You will see the result in a new worksheet as follows. See screenshot:

Notes:

1. The titles of each column will be added before every column.

2. The new worksheet data can be linked to the source data, if you check the Create a link with the active sheet option.

Demo: Printing a list into multiple columns to fit on each printed page in Excel