Fill Left

Fills a selected range of at least two columns with the contents of the far right cell.

If a selected range has only one row, the content of the far right cell is copied into all other cells of the range. If several rows are selected, the far right cells are copied into the cells to the left.