Common function array tasks

Function arrays can be moved within, copied, or removed from a worksheet.

To select an array, do one of the following:

• Select and drag to select every cell in the array. Keep in mind that the array may have empty values, which must also be selected.

• Right-click any part of the array and then select Select DataLink Function to select all cells in the array.

Once selected, you can easily manage the array:

• Manually remove initial $ characters in the formula bar to make cell references relative.

  Note: After you make a change in the formula bar, press Ctrl + Shift + Enter to apply that change.

• Right-click any cell in the array and then select the desired Cut, Copy, Delete, Clear, or Format command.

• Right-click a new cell and then select Paste to reinsert a cut or copied array.

• Place the pointer at the edge of the selected array, and when the pointer becomes a movement pointer, drag the array to a new cell to move it.

  Note: You must move or clear an entire function array, including all cells, otherwise PI DataLink returns an error message: You cannot change part of an array.

• Open the function task pane and update the Output cell field to place the array in a new location. See Update inputs to a function array.

You can also copy the values from a function array if you want to use them elsewhere in a worksheet. After you copy and paste the values, they are no longer part of a function array; they are simply cell values and are not updated. To copy array values:

• Select the function values you want, copy them, and use the Paste Special command to paste values in the desired location.

  You do not need to select the entire array column or row to copy values.