WRAPCOLS in Excel: Arrange a List Down Columns

• Introduced: Preview announced March 16, 2022: Windows Beta 2203 (15104.20004), Mac 16.60 (22030400). Web and Microsoft 365 Current Channel deployment reported September 29, 2022. Release history.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac.
• Checked: October 14, 2026; official WRAPCOLS reference. Documentation check; examples independently calculated, not native-tested.

=WRAPCOLS(vector,wrap_count,[pad_with])

The source must be one row or one column. The final argument controls padding, which defaults to #N/A where the last column has unused positions. A two-dimensional input produces #VALUE!, and a wrap count below 1 produces #NUM!. Official WRAPCOLS reference

WRAPCOLS reshapes values. It does not apply Wrap Text formatting, duplicate the source headings or permanently move the original list.

Put Label in A1. Enter these eight text labels in A2:A9:

SKU01
SKU02
SKU03
SKU04
SKU05
SKU06
SKU07
SKU08

The heading is excluded from the formulas. Use C2 as an output anchor and keep a three-by-three area clear for the first examples.

=WRAPCOLS(A2:A9,3)

Expected output in C2:E4:

SKU01  SKU04  SKU07
SKU02  SKU05  SKU08
SKU03  SKU06  #N/A

Read down the first output column to recover the first three list items, then down the next column. Reading the first output row from left to right yields SKU01, SKU04, SKU07, which is a different sequence.

There are nine positions in the rectangle but only eight source labels. The final position is an error value supplied as default padding, not a ninth label.

=WRAPCOLS(A2:A9,3,"-")

The output is the same three-by-three layout, except the bottom-right position is - instead of #N/A.

Use "" instead of "-" when the unused slot should look empty. An empty-text result still occupies a spill position and cannot be treated as a freely editable blank cell. If an error occurs inside the source list, a padding argument does not mean every error has been removed.

=WRAPCOLS(A2:A9,4,"-")

Expected four-by-two output:

SKU01  SKU05
SKU02  SKU06
SKU03  SKU07
SKU04  SKU08

No padding is needed because eight divides evenly into two groups of four. The supplied dash has no visible effect in this case.

A layout with four labels across each row is a different grouping rule. WRAPROWS performs row-wise grouping; choosing between the two should follow how readers or a printing workflow will consume the list.

=WRAPCOLS(A2:A9,10,"-")

Expected result: one column of eight labels, in their original order. The function does not extend the list to ten rows. Microsoft’s reference specifies a single-column result when the wrap count is at least the number of source elements.

Consequently:

=ROWS(WRAPCOLS(A2:A9,10,"-"))

Expected result: 8, not 10. If a panel must have exactly ten rows, explicit expansion is an additional step; do not assume that an oversized wrap count forces extra padding.

Copy the same eight labels horizontally into B10:I10 on a separate clear part of the sheet. This formula produces the same three-by-three arrangement as Example 2:

=WRAPCOLS(B10:I10,3,"-")

The input orientation can be horizontal or vertical because both are one-dimensional. A rectangle such as B10:E11 is not the same type of input, even if it contains eight cells. Flattening a rectangle first also requires choosing a scan order deliberately.

Check the first, boundary and last items: SKU03 ends the first column; SKU04 begins the second; SKU08 is the last real label. A visually neat rectangle can still be in the wrong reading order.

Keep data headings outside the source vector unless they are intended to be treated as list items. Adjust column widths for long labels separately; formatting does not change the wrap-count rule. If the spill is blocked, move the output or clear the obstruction rather than overwriting a result cell.

• TRANSPOSE in Excel
• INDEX in Excel
• FILTER in Excel

Verification: These are fictional inputs and independently calculated expected results, not native Excel observations. See the editorial testing standards.