User’s Guide : Enhanced Spreadsheet Editing
  
Enhanced Spreadsheet Editing
Array expressions offer you a powerful new language for editing cells in a spreadsheet. You may use these expressions to assign single values or ranges, to modify the existing cells of a spreadsheet using the original or adjacent cells, or to interpolate values.