Up

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

To access this command...

Choose Sheet - Fill Cells - Up.

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