FILL.DOWN
FILL.LEFT
FILL.RIGHT
FILL.UP

Macro Sheets Only

Equivalent to choosing the Down, Left, Right, and Up commands, respectively, from the Fill submenu on the Edit menu.

Syntax

FILL.DOWN( )
FILL.LEFT( )
FILL.RIGHT( )
FILL.UP( )

FILL.DOWN copies the contents and formats of the cells in the top row of a selection into the rest of the rows in the selection.

FILL.LEFT copies the contents and formats of the cells in the right column of a selection into the rest of the columns in the selection.

FILL.RIGHT copies the contents and formats of the cells in the left column of a selection into the rest of the columns in the selection.

FILL.UP copies the contents and formats of the cells in the bottom row of a selection into the rest of the rows in the selection.

Remarks

If you have a multiple selection, each range in the selection is filled separately with the contents of the source range.

Related Functions

COPY Copies and pastes data or objects

DATA.SERIES Fills a range of cells with a series of numbers or dates

FILL.AUTO Copies cells or automatically fills a selection

FORMULA.FILL Enters a formula in the specified range

List of Command-Equivalent Functions