Move or copy an array formula

Show All

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 .