If you need to copy a cell to adjacent cells to the right of it, select the cell plus the cells you want to copy it into (they must all be adjacent) and then press the CTRL and R keys together.
Selecting a single cell and pressing the CTRL and R keys will insert the contents of the cell to the left of it.
Selecting a single cell and pressing the CTRL and R keys will insert the contents of the cell to the left of it.
