Let’s say we have the below table containing the number of different dress items Ordered and Delivered.
Now we need to add another column Shipped between Ordered and Delivered. So we have added the same as follows after column B.
Now we need to fill up the same values as Ordered to Shipped. To do that select all cells in column C and press keyboard shortcut Ctrl+R. This will copy the data from the left cell to right cell. This process can be used for a single cell or for multiple consecutive cells.