EXPAND function - Zoho Sheet - Help Guide

EXPAND

Resizes a given array into a resultant array with specified number of rows and columns.
 
Syntax
 
EXPAND(array; rows; [columns]; [fill_with])
array: The cell range containing the values given as input. Eg., A2:B9
rows: The number of rows to be present in the result array. Eg., 4
columns: The number of columns to be present in the result array. Eg., 3
fill_with: A value to use when one or more text values are missing in the result. Defaults to #N/A if omitted. Eg., "-"
 
Examples
 
Formula
=EXPAND(A2:B9;10;3;"-")

Get a hands-on experience of the function in the embedded range below.

 

Possible Errors
 
Errors
Meaning
#N/A!
  • The function could not find the value it was asked to look for. Commonly occurs in VLOOKUP and similar functions.
  • There is no error in the given cell.
#NAME!
  • The function name is incorrect or invalid.
  • The given defined name (if any) is invalid.
  • There is a typo in the defined name used in the function.
  • Double quotes are missing for text values in the function.
  • Colon missing in a cell range reference.
#VALUE!
  • The given argument's data type is incorrect or invalid.
#REF!
  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.
 
Similar Functions
  • WRAPCOLS
  • WRAPROWS