Inserting a cell in one column based on one condition fro another column

[manojktvm]

Dear Sir,

I have data in one excell sheet(different columns)

A B C
1 1 a
2 2 b
3 3 c
4 4 d
6 5 e
6 f

I need to insert a blank in below to 4 th line in column A.But all the data from other colums should not change
The result need to be like below
A B C
1 1 a
2 2 b
3 3 c
4 4 d
blank cell 5 e
6 6 f

pls help me

[kavinthomash]

select the fifth row. After this click right button of mouse, one pop appear on screen. Choose the insert button. After this process, automatically 5th row will insert in between of 4 th row and 6 th row.