The Excel WRAPROWS function takes a single row or column of values and folds it into a grid, filling row by row at a width you choose. Eight names wrapped at 3 become a 3×3 block. It’s the reshaping tool for name-tag layouts, print sheets, calendars — and the perfect partner for TOCOL.
#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 row — the width of the new grid. |
pad_with | Optional | What to put in the unused cells of the last row. 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 a grid
Eight names sit in a single column, A2:A9. One formula in C1 folds them into rows of three — filling left to right, then moving down:
| A | C | D | E | ||
|---|---|---|---|---|---|
| 1 | Names | Ava | Ben | Cleo | |
| 2 | Ava | Dan | Eli | Fay | |
| 3 | Ben | Gus | Hana | #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 to choose something friendlier:
Try it: interactive WRAPROWS demo
Drag the slider to change wrap_count and watch 10 names reflow into a new grid shape — row by row.
The real power: reshape anything via TOCOL + WRAPROWS
WRAPROWS only accepts a one-dimensional vector — but that’s no limit, because TOCOL turns any shape into one. Together they form Excel’s reshape pipeline:
Classic uses:
- Print layouts: fold a 60-name registration list into a 4-wide page for name tags or seating cards.
- Calendars: wrap a column of 28–31 day numbers at 7 for an instant month grid.
- Re-flowing imports: a system dumps records as one long column with 5 fields per record?
=WRAPROWS(A1:A100, 5)rebuilds the table — one row per record.
Fill down-then-across instead? That’s WRAPCOLS — same arguments, but it fills column by column.
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: =WRAPROWS(TOCOL(range, 1), n).
#N/A in the last row. 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 WRAPROWS only exists in Excel 365 / Excel 2024+; older versions show #NAME?.
Pitfall: row-by-row vs column-by-column. WRAPROWS fills across first. If your data should read down each column instead, you want WRAPCOLS — mixing them up scrambles the order.
Practice workbook
Frequently asked questions
What does the pad_with argument do in WRAPROWS?
wrap_count, the unused cells in the last row are filled with pad_with. Omit it and they show #N/A.What's the difference between WRAPROWS and WRAPCOLS?
wrap_count sets the grid’s width; in WRAPCOLS it sets the height.Can WRAPROWS wrap a two-dimensional range?
Why does my last row show #N/A?
wrap_count, and the default padding is #N/A. Add a third argument: =WRAPROWS(list, 3, "").Which Excel versions have WRAPROWS?
#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