Up

Fills a selected range of at least two rows with the contents of the bottommost cell.

To access this command...

Choose Sheet - Fill Cells - Up.

If a selected range has only one column, the content of the bottommost cell is copied into the selected cells. If several columns are selected, the contents of the bottommost cells are copied into those selected above.