Function Problems

How to Arrange a Long List of Names into Printable Columns in Excel

Huda QurayshiHuda Qurayshi Nov 11, 2026 868 views

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.

How to Arrange a Long List of Names into Printable Columns in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Organize your source data

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'.

2
Select the destination cell

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.

3
Input the dynamic array formula

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.

4
Adjust print layout

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.

Use WRAPCOLS and FILTER Functions to Wrap the List
Dynamic Updates: Because the formula references up to row 500, any new names inserted into the source list will automatically flow into the correct printable column without requiring manual adjustments.
Organize Data with WPS

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. 1. Open your workbook: Launch WPS Spreadsheet and open the file containing your continuous list of names.
  2. 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. 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. 4. Preview and print: Click 'Print Preview' to verify that the rows are wrapping correctly into the designated columns, then proceed to print.
Full support for advanced dynamic array functions like WRAPCOLS and FILTERSeamless compatibility with Microsoft Excel (.xlsx) formats and formulasIntuitive Page Break Preview and print layout settingsFree, lightweight, and user-friendly spreadsheet solution
microsoft office alternative - wps office

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.