Excel shuts down when trying to insert a row. any ideas on why this is happening and how to fix?

catkckozich 

There could be several reasons why Excel crashes when trying to insert a row.

One reason could be that the worksheet has a lot of conditional formatting applied to it.

When conditional formatting is applied separately for each row, Excel crashes when adding a new row at the end of the table.

Another reason could be that a COM add-in is causing the problem.

You can try to determine if a COM add-in is causing the problem by clicking

File > Options > Add-ins > COM Add-ins,

and then clearing all the check boxes in the list, and clicking OK.

 You can then close and restart Excel in normal mode (not in safe mode)

If the above solutions do not work, you can try opening the worksheet with which you’re experiencing difficulties inserting new table rows and selecting the inactive space below the active area of your table. You can try to select the inactive space below the active area of your table and insert a new row