Lookup & Reference
Excel 365
◉ 34 views
Dynamic Array
=WRAPROWS()
WRAPROWS function
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for Mac
=WRAPROWS(vector, wrap_count, [pad_with])
Hover argument names in the table for details.
Output typeArray
Popularity30 / 100
VolatileNo
Dynamic ArrayYes
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =WRAPROWS() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
vector |
Array | Optional | The vector or reference to wrap. |
wrap_count |
Number | Optional | The maximum number of values for each row. |
pad_with |
Any type | Optional | The value with which to pad. The default is #N/A. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
A2 |
A |
B2 |
B |
C2 |
C |
D2 |
D |
E2 |
E |
F2 |
F |
G2 |
G |
A3 |
A |
B3 |
B |
C3 |
C |
D3 |
D |
E3 |
E |
F3 |
F |
G3 |
G |
A4 |
A |
B4 |
B |
C4 |
C |
D4 |
D |
E4 |
E |
F4 |
F |
G4 |
G |
A5 |
A |
B5 |
B |
C5 |
C |
D5 |
D |
E5 |
E |
F5 |
F |
G5 |
G |
Example 1
=WRAPROWS(A2:G2,3)
Example 2
=WRAPROWS(A2:G2,3,"x")
§ Remarks
- The elements of the vector are placed into a 2-dimensional array by row. Each row has wrap_count elements. The row is padded with pad_with if there are insufficient elements to fill it. If wrap_count is greater or equal to the number of elements in vector, then the vector is simply returned in a single row.
✦ Tips
- The elements of the vector are placed into a 2-dimensional array by row. Each row has wrap_count elements. The row is padded with pad_with if there are insufficient elements to fill it. If wrap_count is greater or equal to the number of elements in vector, then the vector is simply returned in a single row.
⚠ Common Errors
#N/A
The default is #N/A. Excel returns a #N/A error for each cell in the return array that has no results.
Fix: در صورت نیاز مقدار pad_with را مشخص کنید یا نتیجه را با IFERROR مدیریت کنید.
#VALUE!
Excel returns a #VALUE when vector is not a one-dimensional array.
Fix: Select a single-row or single-column range
#NUM!
Excel returns a #NUM! when wrap_count is less than 1.
Fix: برای wrap_count عددی بزرگتر یا مساوی ۱ وارد کنید.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!