If you are trying to insert a row in Excel worksheet and the Insert option is disabled, then below solution can help you.
You would have encountered this problem due to the Excel settings being modified by a third party Excel Application or a malicious script.
Follow below steps to enable the Insert option to Insert Rows in Excel.
1. Open Excel
2. Press [ALT]+F11 or Go to Developer>Visual Basic menu option to open Visual Basic Editor.
3. Press [CTRL]+G to open Immediate Window.
4. Type below code in this Immediate Window
Application.CommandBars("Row").Controls("Insert").Enabled = True
5. Press [ENTER] key
6. Close the Visual Basic Editor window and go back to Excel.
You should see the Insert option enabled now.
I faced this issue while filing my income tax returns last time.
This option is disabled in MS Excel due to a bug in the Indian Income Tax Department’s Excel macro.