Skip to content
ExcelExcel 2024+

WRAPROWS function in Excel

Wraps the provided row or column of values by rows after a specified number of elements

=WRAPROWS(vector, wrap_count, [pad_with])

WRAPROWS syntax and parameters

Three arguments, two required.

  • vectorarrayRequired
  • wrap_countnumberRequired
  • pad_withanyOptional

WRAPROWS examples

Formulas you'll actually reuse.

  1. Thirty daily values laid out as calendar-style rows of seven:

    =WRAPROWS(A2:A31, 7)

  2. Pad the short final week with blanks instead of #N/A:

    =WRAPROWS(A2:A31, 7, "")

WRAPROWS in Google Sheets

Same name — your formula ports as-is.

Try WRAPROWS in the playground

Edit the example — nothing to install.

Preloaded with the WRAPROWS formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.