Move or copy an array formula

  1. Select the entire array range.

    How?

    1. Select a cell within the array.
    2. Press CTRL+/ (forward slash).

    Click Cut or Copy on the spreadsheet toolbar.

  2. Select the entire destination range; otherwise, the array will be pasted into a single cell.
  3. Click Paste .