Double Click to insert a new row doesn't work on all worksheets

l discovered last year that when I double click on a cell in an excel worksheet, it adds a new row. I have learned to love this feature in 1 particular worksheet. I just discovered that this does not happen on most of my worksheets. (On most worksheets, when you double click a cell, it enables editing of that cell). I have a spreadsheet with many worksheets. 1 of the worksheets behaves with the double click to add a row feature, and most of the others behave the second way. I want to have another worksheet that behaves the first way (double clicking adds another row). When I copy my entire worksheet to a new worksheet, they still behave differently. I don't remember where I learned about the "double click to add a row" feature, but I felt like I was missing out for many years. Now, it seems to be impossible to find somebody to explain how that ever worked. I know I didn't write a macro or anything to get it. Can anybody explain? Any help would be greatly appreciated.

I'm attaching a sample file. In worksheet "2018" double clicking only allows editing of a cell, but in worksheet "2019" double clicking creates a new row. I don't remember doing anything to get this to happen.

As suspected, you have a code in the worksheet 2019.

Right sheet the sheet tab and select view code to see the before double click code.

Copy and paste that exact same code into 2018 tab module
-


RightClick tab.jpg

If there were no codes, you would not have had to save the workbook as .xlsm

The code says "udpatedby extend office" possibly you were experimenting with code on websites, I think they are also involved with Kutools.

Doesn't really matter whose name is on the code, it's just how you insert a row using the worksheet_beforedoubleclick event.