Fills a selected range of at least two rows with the contents of the top cell of the range.
Choose Sheet - Fill Cells - Down.
If a selected range has only one column, the contents of the top cell are copied to all others. If several columns are selected, the contents of the corresponding top cell will be copied down.