User`s guide

Function Utilities
• The Advanced tab creates a rectangular array of copies of the current
function in the current worksheet, and optionally copies the cell contents of
ranges referenced by the function’s arguments.
When you set the number of rows and columns and the row/column
increments, the copy process automatically updates cell references by the
specified increment amounts.
- Positive increments move rows down and columns to the right.
- Negativeincrementsmoverowsupandcolumnstotheleft.
The following example shows the Advanced tab:
Move Function Dialog Box
Use the Move Function dialog box to mo ve the curre ntly selected function to a
new position in the current w orksheet.
When you set the row and column increments, the move process automatically
updates cell references by these values.
4-15