I have an excel sheet as shown below. As I don't have privilege to paste image, it is uploaded as link

Original data format

I would like to insert the highlighted records on top of the rows shown.

When I select all the 4 rows and 2 columns to be copied and click on "Insert cut cells", it doesn't work the way I want it. Instead the output looks like as shown below which is incorrect. As you can see, the 'father', 'mother', 'brother' rows which have to be below the pasted/inserted records, is moved to the next column.This is incorrect and not an expected output

Incorrect image copy pasted

Hence, I would like to be able to get the output as shown below

Is it possible in Excel to get an output as shown below by copy and paste/insert?

Expected output

1 Answer 1


I was able to do with this with the help of a simple macro/vba code. AFAIK, Excel doesn't have any option to change the default when inserting rows

Sub ShiftDown()
Selection.Insert Shift:=xlDown
End Sub

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.