How do I insert copied cells between cells?

While preparing Excel Reports and Excel Dashboards in Microsoft Excel, we need to copy a cell / cells from another file and insert these in our file without overwriting the existing Data.

Shortcut to Insert copied Cell/Cells without overwriting existing Data Using Keyboard

To copy and paste the cell(s) containing data without overwriting existing data:-

Here we have the Data as shown in below image

1. Copy the Cell/Cells containing data
2. Select the Cell/Cells within the range of cells that should not be overwritten
3. Press Ctrl++ (plus sign) to open the Insert dialog box
4. Select Shift cells right or Shift cells down or you can select Entire row or entire column depending on the data
5. Click OK

Insert the copied Cell/Cells without overwriting existing Data Using Mouse

To copy & paste a cell(s) without overwriting existing data, using both the keyboard shortcut and the mouse:

1. Select the Cell/Cells that contain the data to be copied
2. Hold the CTRL+Shift keys
3. Move the mouse over the selection border
4. When cursor changes to a small cross
5. Drag the Cell/Cells to a new location and paste it
6. Notice the gray line bar that follows the mouse
7. Position it in the new location
8. Release the mouse

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at

I'm trying to copy a block of cells, but instead of shifting down the rest of the rows, it overwrites them

How do we copy and paste a set of cells and shift the rest so nothing is lost?

asked Sep 27, 2013 at 13:12

Instead of clicking "Paste", right-click or Ctrl click and select "Insert Copied Cells" or "Insert...", depending on your version of Excel.

This will give you an option to shift cells right or down.

If you cut cells, the context menu will have the option to "Insert Cut Cells" instead. Microsoft has a support article that describes these steps and other copy/paste options.

In the Mac Version it's:

answered Sep 27, 2013 at 13:21

John BensinJohn Bensin

1,52716 silver badges23 bronze badges

6

So, this option works great, but only if you're working within the same workbook. I ended up here because the "Insert copied cells" option does not exist if you're trying to paste rows/cells from another workbook.

The simplest workaround I found was to copy the rows or cells you want from the one workbook, then paste them in a new blank sheet of the workbook you want to ultimately insert them into, the re-copy them from that new sheet, right-click the location you want to insert them on the worksheet, and the "Insert copied cells" option should now show up. Choose that, and you're done!

answered Apr 14, 2017 at 18:41

T SchulzkeT Schulzke

531 silver badge3 bronze badges

2

I was also facing same problem; I came up with this solution: while doing copy and paste follow these steps:

1. Instead of selecting only particular bunch of cells, select whole rows before copying. This can be done by dragging the mouse in the left side number list.
2. You can go and paste it anywhere. And this time, you will be amazed that there's no overlap.

Toby Speight

4,7781 gold badge25 silver badges36 bronze badges

answered Feb 8, 2017 at 14:28

1

To fulfill this step with a keyboard shortcut, check out this article.

There are two options that I am aware of and both (unfortunately) require two steps.

Option 1

1. With a single cell selected, hit Shift + Space to select the row.
2. Hit Control + Shift + + (Plus Sign) to insert a row above the current row.

Option 2

1. With a single cell selected, hit Control + Shift + + (Plus Sign) to insert a row.
2. Hit Enter to accept the default of Shift Cells Down.

If inserting many rows at once, I think the first option is the best since you can repeat the second step without having to re-select the row.

This inserts a new empty row. To copy the row, you just need to hit Ctrl+C between the steps one and two. This way the content gets automatically pasted after step two.

answered Jul 25, 2017 at 6:19

Sort them according to color or text and when they are one row, cut and paste it in desired location. Blanks can then be removed. This logic applies to major cases

answered Nov 20, 2017 at 13:27

Excel for Mac 2011:

(This is a bit of an aside -- for moving without overwriting, rather than copying). Use shift-drag, i.e.

• select the cells you want to move
• keeping the shift key pressed, drag the cells
• drop the cells where you want (and then release the shift key)

microsoft-excel-2011-for-mac

answered Jun 11, 2018 at 15:52

Why isn't insert copied cells working?

How to copy data from one cell to another in Excel automatically?