Edit - Fill / Standardize Block - Fill / Copy Right

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

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

...to copy an identical value into a horizontal block (row) of selected cells. For example, you can select a block of cells in a spreadsheet (some cells can be blank), and use this command to copy the number from the left-most selected cell into all selected cells. In the illustration below, the original block of selected cells includes the numbers 4, 9, 6 and 2, as well as a blank cell.

The next illustration displays the results after selecting Copy Right.

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