Inserting Copied Cells

Summary

Instructions on how to insert copied cells in Excel 2016 without overwriting data.

Body

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.

Details

Details

Article ID: 2503
Created
Tue 1/3/17 4:15 PM
Modified
Wed 1/18/17 12:29 PM