Lookup & Reference
Excel 365
◉ 11 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 — Coming soon
▦ 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
پیچیدن بردار A2:G2 به سطرهایی با حداکثر ۳ مقدار
=WRAPROWS(A2:G2,3)
پیچیدن بردار A2:G2 به سطرهایی با حداکثر ۳ مقدار و پر کردن با x
=WRAPROWS(A2:G2,3,"x")
✦ 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!