Copy a function

You can copy functions to different locations in the worksheet. This is useful when creating additional functions that are only slightly different than existing functions.

To copy a function:

1. In the worksheet, select the range of cells that contains the array formula. To select all of the array cells, insert the mouse cursor in the array and then press CTRL+/ on your keyboard, where / is the forward slash.

2. Press CTRL+C to copy the function.

3. Insert the mouse cursor in the new location for the function.

4. Press CTRL+V to paste the function.

For information on manually editing a function, see Manually Editing a Function.