Lookup & Reference Function - EXPAND

Simply put, this function will take an existing array and enable you to expand the rows and/or columns contained within it. You can 'pad' these additional cells out with an appropriate value.

The video shows the EXPAND function in use.

The written calculation is below:

=EXPAND(B3:D8,12,4,"Enter Data")

​In this example, B3:D8 is the array we want to extend.

12 is the number of rows we want to expand our array to.

4 is the number of columns we want to expand to.

The text string "Enter Data" is the value we want to appear in the newly added cells. This is known as the pad_with argument.