Inserting Copied Cells

Issue/Question

How do I merge or insert copied cells into my Excel spreadsheet without overwriting the information that is already there?

Environment

  • Microsoft Excel 2016

Resolution

  1. Copy the data from spreadsheet 1.
  2. Choose where the data needs to be inserted into spreadsheet 2.
  3. a. If you are inserting rows, right-click on the row number below where the data should go (it will be inserted above).
    b. If you are inserting columns, right-click on the column number to the right of where the data should do (it will be inserted to the left).
  4. Choose Insert Copied Cells.
  5. Choose Shift cells down or right, as appropriate.
  6. Click OK.
Print Article