Edit - Fill / Standardize Block - Fill / Copy Down

Ribbon bar. Select the Edit tab. In the Fill group, click Copy Down...

Classic menus. From the Edit - Fill / Standardize Block submenu, select Fill / Copy Down...

..to copy an identical value into a vertical block (column) of selected cells. For example, you can select a block of cells in a spreadsheet (some cells can be blank), and then use this option to copy the number from the top selected cell into all the selected cells. Using the illustration below, the original block of selected cells includes the numbers 4, 5, 9 and 2, as well as a blank cell.

The illustration below displays the results after selecting Copy Down.

All selected cells have been populated with the number 4, which was the value in the top cell prior to completing this action. See also: Standardize Block - Fill/Copy Right, Standardize Block - Fill Random Values, Standardize Block - Standardize Columns, Standardize Block - Standardize Rows.