How to copy and paste without overwriting in Excel - Super User 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
Do not paste into cells that already contain data To achieve the behavior where you copy a range of data to a target area in Excel but do not overwrite existing data in the target cells, you can use a combination of formulas and conditional logic