How to Insert Copied Cells Multiple Times in Excel
Microsoft Excel 2013 provides a clipboard manager to paste or insert previously selected ranges multiple times.
When you use the Copy feature to mirror cells in a new location, you can paste the cells multiple times as long as you don't copy or edit any other cell. If you do, the copied cells are deselected and no longer available to copy until you reselect them. Excel 2013 does include Office Clipboard that quickly accesses previously copied cells for one-click pasting at any time. While this function is exceedingly helpful, it still won't allow you to use the Insert Copied Cells command, which moves existing cells to accommodate copied data, after the first usage. There is, however, a workaround that saves you from moving back to recopy the original cells. that quickly accesses previously copied cells for one-click pasting at any time. While this function is exceedingly helpful, it still won't allow you to use the Insert Copied Cells command, which moves existing cells to accommodate copied data, after the first usage. There is, however, a workaround that saves you from moving back to recopy the original cells.
Using Excel's Office Clipboard
Select the Home tab and click the bottom right arrow in the Clipboard group to open the Clipboard pane.
The Clipboard pane references only the last cells to be copied prior to opening the pane, but it references all copied cells subsequent to opening the pane. To ensure your copied cells are available in Office Clipboard, open the Clipboard pane before copying any cells.
Click the top left cell where the data should appear.
Click the appropriate entry in the Clipboard pane to copy the cells. Repeat as necessary to recopy the data to other locations.
Data copied using this method overwrites any existing data in the copy range. To prevent overwriting data, consider inserting the data instead, as described in the Inserting Data From Office Clipboard section.
Inserting Data From Office Clipboard
Highlight the range where the insert data will appear. The selected area should contain at least enough cells to hold all copied data.
If you're uncertain of the range's size, select the top left cell of the proposed range and click the appropriate entry from the Clipboard pane. The data will be overwritten, but the resulting highlighting shows you exactly where the data will go. Then press Ctrl-Z to undo the copy and restore your original data.
Right-click the selected cells and click Insert.
Choose how the existing cells should move and click OK. In the image above, Shift Cells Down moves the columns, starting with the topmost selection, down five rows, which is the number of rows highlighted.
Select the top left cell of the range where the copied data should appear.
Click the appropriate entry from the Clipboard pane to paste the data. Because you already shifted the range of cells to create blank cells, no data is overwritten. Repeat as necessary to insert cells in multiple locations.