EXPAND

The EXPAND function adds rows or columns to an array based on specified dimensions.

EXPAND(array, number-of-rows, number-of-columns, pad-with)

array: The array to expand.

number-of-rows: The number of rows in the expanded array.

number-of-columns: The number of columns in the expanded array.

pad-with: The value to fill the expanded rows and columns.

Notes

  • If number-of-rows or number-of-columns is not provided, the default value is the current number of rows or columns in the array.

  • If the selected array includes empty cells, the function fills the empty cells with 0.

  • EXPAND returns an error when number-of-rows or number-of-columns is less than the rows or columns in the array.

  • EXPAND returns an error in padded cells if pad-with is not provided.

  • EXPAND returns an error if the array is too large.

  • To fill padded cells with a non-numeric value, enter the value in quotation marks.

  • You can use the spilled range operator “#” to reference an array created by a formula.

Examples

=EXPAND(A1:E5, 6,6,0) adds an additional row and column filled with 0.

=EXPAND(A1:E5, 6,,“-”) adds an additional row filled with dashes.

See alsoDROPTAKEUNIQUE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
உதவியாக இருந்ததா?
எழுத்தின் அளவு: 250
அதிகபட்ச எழுத்தின் அளவு: 250
உங்கள் கருத்திற்கு நன்றி.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.