How to Insert Copied Cells Multiple Times in Excel

By C. Taylor

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

Step 1

Select the Home tab and click the bottom right arrow in the Clipboard group to open the Clipboard pane.

Tip

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.

Step 2

Selecting the copy location

Click the top left cell where the data should appear.

Step 3

Copying the data

Click the appropriate entry in the Clipboard pane to copy the cells. Repeat as necessary to recopy the data to other locations.

Warning

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

Step 1

Highlight the range.

Highlight the range where the insert data will appear. The selected area should contain at least enough cells to hold all copied data.

Tip

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.

Step 2

Choosing the Insert option

Right-click the selected cells and click Insert.

Step 3

Shifting the cells

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.

Step 4

Choosing the Insert location

Select the top left cell of the range where the copied data should appear.

Step 5

Inserting the cells

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.