WRAPCOLS Function
Wraps a single list into columns of a set height.
Category
Lookup & Reference
Available in
Microsoft 365, Excel 2024
Returns
A spilled 2D array
Want to practice WRAPCOLS in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
WRAPCOLS takes one row or column of values and fills them down into columns, starting a new column every wrap_count items.
Any leftover spaces in the last column are filled with #N/A, or the value you choose.
Syntax
=WRAPCOLS(vector, wrap_count, [pad_with])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| vector | Yes | A single row or column of values. |
| wrap_count | Yes | How many values per column. |
| pad_with | Optional | What to fill empty spots with. Defaults to #N/A. |
Examples
Example 1 — A list into columns of 3
Wrap five names into columns three tall.
C1fx=WRAPCOLS(A1:A5, 3, "")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Ana | Ana | Dev | |
| 2 | Ben | Ben | Eli | |
| 3 | Cara | Cara | ||
| 4 | Dev | |||
| 5 | Eli |
=WRAPCOLS(A1:A5, 3, "") Explain
Example 2 — Printing a long list
Fit a 120-name list onto one page by wrapping into columns of 40.
=WRAPCOLS(A2:A121, 40, "") Explain
Common mistakes
- #VALUE! errors. vector is a 2D range. Flatten it first with TOCOL.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.