Lookup & Reference Excel 365 ◉ 39 views Dynamic Array

=EXPAND()

Q: What does the #NUM! error mean in the EXPAND function?

Excel returns a #NUM when array is too large. — Fix: ابعاد درخواستی را کاهش دهید یا آرایه مبدأ را کوچکتر کنید.

EXPAND Function

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for Mac

=Expand(array, rows, [columns], [pad_with])

Hover argument names in the table for details.

Output typeArray

Popularity10 / 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 =EXPAND() 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)

Download EXPAND.xlsx ~ 8–12 KB · No macros

Quiz this function

%d questions — syntax, example & errors — test yourself!

Start quiz →

◧ Arguments

Argument	Type	Required	Description
`array`	Array	Optional	The array to expand.
`rows`	Number	Optional	The number of rows in the expanded array. If missing, rows will not be expanded.
`columns`	Number	Optional	The number of columns in the expanded array. If missing, columns will not be expanded.
`pad_with`	Any type	Optional	The value with which to pad. The default is #N/A.

▣ Examples

▦ Data

Cell	Value
`A2`	1
`B2`	2
`A3`	3
`B3`	4
`A4`	1
`B4`	2
`A5`	3
`B5`	4
`A6`	1
`B6`	2
`A7`	3
`B7`	4
`A8`	1
`B8`	2
`A9`	3
`B9`	4

Example 1 =EXPAND(A2:B3,3,3)

Example 2 =EXPAND(A2,3,3, "-")

§ Remarks

If rows isn't provided or is empty, the default value is the number of rows in the array argument.
If columns isn't provided or is empty, the default value is the number of columns in the array argument.

✦ Tips

If rows isn't provided or is empty, the default value is the number of rows in the array argument.
If columns isn't provided or is empty, the default value is the number of columns in the array argument.

⚠ Common Errors

#N/A The default is #N/A. Excel returns a #N/A error in padded cells if pad_with is not provided.

Fix: اگر نمی‌خواهید ‎#N/A ببینید، برای pad_with مقدار دلخواه مانند "-" یا ۰ وارد کنید.

#VALUE! Excel returns a #VALUE error when the rows or columns argument is less than the rows or columns in the array argument.

Fix: Use a number equal to or greater than the current dimensions

#NUM! Excel returns a #NUM when array is too large.

Fix: ابعاد درخواستی را کاهش دهید یا آرایه مبدأ را کوچک‌تر کنید.

💬 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!