SOLVED

In the context menu of excel, the commands to insert and delete a row are gone, how to get it back?

%3CLINGO-SUB%20id%3D%22lingo-sub-2325461%22%20slang%3D%22en-US%22%3EIn%20the%20context%20menu%20of%20excel%2C%20the%20commands%20to%20insert%20and%20delete%20a%20row%20are%20gone%2C%20how%20to%20get%20it%20back%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2325461%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day!%3CBR%20%2F%3EIn%20an%20excel%20document%2C%20when%20I%20clicked%20on%20a%20row%20or%20column%2C%20the%20commands%20disappeared%20to%20insert%20a%20new%20row%20or%20set%20an%20existing%20one.%20Another%20document%20contains%20these%20commands.%20New%20documents%20also%20lack%20such%20buttons.%20They%20remained%20on%20the%20taskbar%2C%20but%20this%20is%20very%20inconvenient.%20Has%20anyone%20encountered%20such%20a%20problem%3F%20How%20do%20I%20return%20these%20functions%20to%20the%20context%20menu%3F%3CBR%20%2F%3EOffice%20365%20license.%20Tried%20to%20restore%20the%20office%20of%20Microsoft%20funds.%20On%20another%20laptop%20with%20the%20same%20file%20all%20works%20fine.%3C%2FP%3E%3CP%3EThere%20is%20no%20sheet%2Fbook%20protection.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%221.jpg%22%20style%3D%22width%3A%20749px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278364i72FF3A583B655012%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221.jpg%22%20alt%3D%221.jpg%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222.jpg%22%20style%3D%22width%3A%20749px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278365iF2D48DA1F293F735%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222.jpg%22%20alt%3D%222.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2325461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2328728%22%20slang%3D%22en-US%22%3ERe%3A%20In%20the%20context%20menu%20of%20excel%2C%20the%20commands%20to%20insert%20and%20delete%20a%20row%20are%20gone%2C%20how%20to%20get%20it%20ba%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2328728%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1045561%22%20target%3D%22_blank%22%3E%40DmitriySmirnov%3C%2FA%3E%26nbsp%3BI%20am%20having%20the%20same%20problem!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2328865%22%20slang%3D%22en-US%22%3ERe%3A%20In%20the%20context%20menu%20of%20excel%2C%20the%20commands%20to%20insert%20and%20delete%20a%20row%20are%20gone%2C%20how%20to%20get%20it%20ba%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2328865%22%20slang%3D%22en-US%22%3Echeck%20your%20worksheet.%20Does%20it%20have%20column%20labels%20all%20the%20way%20to%20the%20end%20to%20the%20right%20without%20any%20data%20in%20the%20columns%3F%20(eg%20you%20have%20reached%20the%20maximum%20number%20of%20columns)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2350315%22%20slang%3D%22en-US%22%3ERe%3A%20In%20the%20context%20menu%20of%20excel%2C%20the%20commands%20to%20insert%20and%20delete%20a%20row%20are%20gone%2C%20how%20to%20get%20it%20ba%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2350315%22%20slang%3D%22en-US%22%3EThe%20problem%20is%20solved%3A%20I%20just%20reinstall%20all%20Add-ins%20and%20all%20works%20fine.%3CBR%20%2F%3EFile%20-%20Options%20-%20Add-ins%3C%2FLINGO-BODY%3E
Occasional Visitor

Good day!
In an excel document, when I clicked on a row or column, the commands disappeared to insert a new row or set an existing one. Another document contains these commands. New documents also lack such buttons. They remained on the taskbar, but this is very inconvenient. Has anyone encountered such a problem? How do I return these functions to the context menu?
Office 365 license. Tried to restore the office of Microsoft funds. On another laptop with the same file all works fine.

There is no sheet/book protection.

1.jpg2.jpg

4 Replies
check your worksheet. Does it have column labels all the way to the end to the right without any data in the columns? (eg you have reached the maximum number of columns)
The problem is solved: I just reinstall all Add-ins and all works fine.
File - Options - Add-ins
best response confirmed by allyreckerman (Microsoft)
Solution
The problem is solved: I just reinstall all Add-ins and all works fine.
File - Options - Add-ins