Excel WRAPROWS: Turn a List Into Rows Instantly

The WRAPROWS function in Excel lets you take a long list and automatically arrange it into rows — perfect for labels, grids, or clean layouts.

No copying. No dragging. Just one formula.

Syntax

WRAPROWS(vector, wrap_count, [pad_with])

• vector — your list

• wrap_count — items per row

• pad_with — optional fill value

Example

Column list:

Formula:

=WRAPROWS(A2:A7,3)

Result:

Real Use

WRAPROWS is great for:

• Mailing labels

• Product layouts

• Seating charts

• Print grids

Watch the full WRAPROWS video here:

EXERCISE FILE:

ExcelWrapRowsFunction-01.xlsx

Download XLSX • 11KB