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

ArgumentRequired?What it does
vectorYesA single row or column of values.
wrap_countYesHow many values per column.
pad_withOptionalWhat 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, "")
ABCD
1AnaAnaDev
2BenBenEli
3CaraCara
4Dev
5Eli
=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

Kyle Stott

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.