Contact
12 programs
Explore the site

WRAPROWS in Excel: Arrange a List into Rows

Lookup Intermediate Microsoft Excel

Reshape an Excel list with WRAPROWS, control items per row and padding, and verify partial final rows and oversized wrap counts.

Verification status: See the evidence and test scope described in this guide. How formula examples are checked

Quick answer: WRAPROWS takes a one-dimensional list and places its items across rows, starting a new row after the chosen number of items. It is useful for compact display grids and label layouts.

Availability and version history

  • First introduced: Preview announced March 16, 2022, for Windows Beta 2203 (build 15104.20004) and Mac 16.60 (build 22030400); web and Microsoft 365 Current Channel deployment reported September 29, 2022. Official introduction.
  • Current documented status: the dedicated help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac. Availability depends on the installed build.
  • Evidence checked: October 14, 2026. Official WRAPROWS help. Examples below were independently calculated, not executed in Excel.

Syntax and padding

=WRAPROWS(vector,wrap_count,[pad_with])

vector must be one row or one column. wrap_count sets the maximum number of items per output row. If a final row needs padding, the default filler is the error #N/A; the third argument supplies a different filler. WRAPROWS reference

This rearranges values into a new spill range. It does not insert line breaks inside the original cells, apply visual Wrap Text formatting, or move the source list.

Prepare seven short labels

Enter heading Label in A1 and the labels A, B, C, D, E, F and G in A2:A8, one per cell. The formula will exclude the heading.

Use C2 as the output anchor and keep the surrounding rectangle empty. Seven items will require three rows when each row holds at most three items.

Example 1: three items per row

=WRAPROWS(A2:A8,3)

Expected result in C2:E4:

A  B     C
D  E     F
G  #N/A  #N/A

The first row consumes items 1–3, the second consumes 4–6, and the final row contains item 7 plus two padding errors. The two #N/A cells do not indicate missing source records: they are the documented default padding for this shape.

Do not use a blanket error replacement without considering whether errors also occur in the source. An explicit padding argument communicates the intended layout more clearly.

Example 2: use a visible padding mark

=WRAPROWS(A2:A8,3,"-")

Expected output:

A  B  C
D  E  F
G  -  -

The seven original labels are unchanged. The hyphens identify unused display positions. This is useful for a review table where an empty-looking position might otherwise be mistaken for a missing value.

To make unused positions look empty instead, use:

=WRAPROWS(A2:A8,3,"")

The last two result cells then contain empty text. They are still part of the spill; they are not physically empty worksheet cells available for manual entry.

Example 3: change the panel width

=WRAPROWS(A2:A8,4,"-")

Expected output is two rows by four columns:

A  B  C  D
E  F  G  -

The required number of rows is the seven-item count divided by four, rounded upward: two. Changing the width changes the position of the later items, so a separate formatted label-printing area may need its widths and page layout adjusted.

Advanced boundary check: a width larger than the list

=WRAPROWS(A2:A8,10,"-")

Expected output is one row of seven values: A, B, C, D, E, F, G. Microsoft specifies that when the wrap count is at least the number of vector items, the vector is returned as a single row. It is not extended to ten columns with three extra hyphens.

This check therefore returns 7:

=COLUMNS(WRAPROWS(A2:A8,10,"-"))

If a downstream template requires exactly ten columns even for a shorter list, that is an additional sizing requirement. Do not assume WRAPROWS alone guarantees that width in this boundary case.

Input and error checks

The official help documents #VALUE! for a source that is not one-dimensional and #NUM! when the wrap count is below 1. Use a positive whole-number count in these examples. A source such as A2:B8 is a two-dimensional table, so decide how it should be flattened before wrapping it.

A blocked spill must be resolved in the output area. Keep manually typed headings outside that rectangle. The source heading A1 is not included because the formula explicitly starts at A2.

For real labels, test the full items rather than only single characters: long text may require wider columns even when the array dimensions are correct. Display formatting does not change how WRAPROWS groups the values.

Verification: Inputs are fictional. Expected values and array shapes were independently calculated from these inputs; no native Excel execution or screenshot is claimed. See the editorial testing standards.