The Excel WRAPCOLS function takes a single row or column of values and folds it into a grid, filling column by column at a height you choose. Eight names wrapped at 3 become three columns of three. It’s the down-then-across twin of WRAPROWS — ideal for newspaper-style columns and fixed-height layouts.
#N/A.
Syntax
| Argument | Description | |
|---|---|---|
vector | Required | The values to wrap — must be a single row or a single column. |
wrap_count | Required | How many values per column — the height of the new grid. |
pad_with | Optional | What to put in the unused cells of the last column. Default is #N/A. |
Available in: Excel for Microsoft 365, Excel 2024+, and Excel for the web. Older versions show #NAME?.
Wrap a flat list into columns
Eight names sit in a single column, A2:A9. One formula in C1 folds them into columns of three — filling top to bottom, then moving right:
| A | C | D | E | ||
|---|---|---|---|---|---|
| 1 | Names | Ava | Dan | Gus | |
| 2 | Ava | Ben | Eli | Hana | |
| 3 | Ben | Cleo | Fay | #N/A | |
| 4 | Cleo | ||||
| 5 | Dan | ||||
| 6 | Eli | ||||
| 7 | Fay | ||||
| 8 | Gus | ||||
| 9 | Hana |
Eight values don’t divide evenly by 3, so the final cell gets the default #N/A padding. Supply pad_with for something friendlier:
Try it: interactive WRAPCOLS demo
Drag the slider to change wrap_count and watch 10 names reflow into a new grid shape — column by column.
The real power: layouts with a fixed height
Use WRAPCOLS when the number of rows is the constraint: a printable page that fits 20 lines, a directory that should read top-to-bottom like a phone book, or a sidebar that can only be so tall:
And like its sibling, it pairs with TOCOL to reshape any range, not just vectors:
Which wrap do I want? Read your layout out loud. "Across, then down" (rows of N) is WRAPROWS. "Down, then across" (columns of N) is WRAPCOLS. wrap_count is the width in the first case and the height in the second.
Errors & common pitfalls
#VALUE! — vector isn’t one-dimensional. The first argument must be a single row or single column. To wrap a 2-D range, flatten it first: =WRAPCOLS(TOCOL(range, 1), n).
#N/A in the last column. Not a bug — it’s the default padding when the list doesn’t divide evenly by wrap_count. Supply pad_with (even just "") to replace it.
#NUM! — bad wrap_count. wrap_count must be at least 1. Zero or negative values throw #NUM!.
#SPILL! / #NAME? The output grid needs empty cells to land in — and WRAPCOLS only exists in Excel 365 / Excel 2024+; older versions show #NAME?.
Pitfall: wrap_count means height here. In WRAPROWS it’s the row width; in WRAPCOLS it’s the column height. Swapping the two functions transposes your layout and reorders every value.
Practice workbook
Frequently asked questions
What's the difference between WRAPCOLS and WRAPROWS?
wrap_count sets the grid’s height; in WRAPROWS it sets the width.What does the pad_with argument do in WRAPCOLS?
wrap_count, the unused cells in the last column are filled with pad_with. Omit it and they show #N/A.Can WRAPCOLS wrap a two-dimensional range?
How many columns will WRAPCOLS produce?
wrap_count, rounded up. 10 values wrapped at 4 give 3 columns — two unused cells in the last column get the padding.Which Excel versions have WRAPCOLS?
#NAME?.Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class