Arrays

An array is a one- or two-dimensional table of data stored in a single cell.

Arrays are a facility which enable you to write formulae which process a lot of data at once.

Entering arrays

The simplest way to create an array is to enter a reference to a range.

To create an array containing the contents of cells A1 to B3, you would do the following:

  1. Type some numbers into the cells A1 to B3. These cells should be number cells.
  2. Select the cell which is to contain the array.
  3. Click in the formula line.
  4. Enter the range A1:B3 either by typing in the reference or by pointing at cell A1 and then dragging to B3 to select the range.
  5. Click the Tick button or press Return.

See also Typing arrays directly into cells and Displaying arrays.