How to Arrange a Long List of Names into Printable Columns in Excel
Question details
The user needs a method to organize a single, continuous long list of names into multiple side-by-side columns with a fixed row limit for efficient printing, ensuring new names flow automatically.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Preparing a long dataset (e.g., a list of 140+ names) for a physical printout where a single column would waste paper and look poorly formatted.
- Observed behavior
- A single continuous column of data takes up too many pages vertically when printed, instead of filling the width of the page in organized multi-column tables.
Determine the exact number of rows you want to display per printed column based on your paper size, and ensure your source data sheet does not contain unnecessary blank cells between names.
Use WRAPCOLS and FILTER Functions to Wrap the List
Use Excel's dynamic array functions to automatically filter out blank cells and wrap your continuous list into a specified number of rows per column.
The WRAPCOLS function is specifically designed to convert a single row or column of values into a two-dimensional array by wrapping the values after a specified number of elements. Wrapping your list ensures the data is formatted optimally for printing.
By nesting the FILTER function inside WRAPCOLS, you can ensure that empty cells at the bottom of your data range are ignored, allowing for dynamic additions in the future.
Keep all your names in one continuous column on a dedicated sheet. For example, place your names in column A on a sheet named 'Data Sheet'.
Open a new worksheet designated for printing, and click on the top-left cell (e.g., cell A1) where you want the multi-column table to begin.
Type the formula =WRAPCOLS(FILTER('Data Sheet'!A2:A500,'Data Sheet'!A2:A500<>""), 30, "") and press Enter. The number '30' sets the row limit per column; change this value to fit your specific page height.
Go to the 'Page Layout' tab on the ribbon, use 'Margins' to widen your printable area, and adjust individual column widths to ensure the names fit neatly on the printed page.

Easily Manage Long Lists and Print Layouts with WPS Spreadsheet
WPS Spreadsheet fully supports advanced dynamic array formulas like WRAPCOLS and provides an intuitive Page Break Preview to help you format long lists perfectly for printing.
- 1. Open your workbook: Launch WPS Spreadsheet and open the file containing your continuous list of names.
- 2. Apply the WRAPCOLS formula: In a new sheet, enter the WRAPCOLS and FILTER formula to automatically distribute your single column into multiple columns.
- 3. Configure page layout: Navigate to the 'Page Layout' tab and select 'Page Setup' to adjust margins, orientation, and column scaling to fit your paper size.
- 4. Preview and print: Click 'Print Preview' to verify that the rows are wrapping correctly into the designated columns, then proceed to print.

Frequently Asked Questions
How do I change the number of rows per column in the formula?
In the formula =WRAPCOLS(array, wrap_count, pad_with), the 'wrap_count' argument dictates the row limit. Simply change the number in the middle of the formula (e.g., from 30 to 40) to display 40 rows per column.
How do I remove the #N/A error at the end of my wrapped columns?
Ensure you include the 'pad_with' argument at the end of your WRAPCOLS formula. Using two double quotes ("" ) as the final argument, like =WRAPCOLS(A1:A100, 30, ""), forces Excel to display blank cells instead of #N/A errors when the data runs out.
Why is my dynamic array formula returning a #SPILL! error?
A #SPILL! error occurs when there is existing text, data, or spaces blocking the formula from expanding into the adjacent cells. Clear the surrounding cells to the right and bottom of your formula to allow the data room to spill properly.
What if my version of Excel does not support WRAPCOLS?
If you are using an older version of Excel without dynamic array functions, you can achieve a similar result using a combination of the INDEX, ROW, and COLUMN functions, or by manually cutting and pasting chunks of data.




