Home

How to delete cell, if there is no "Delete" command?

%3CLINGO-SUB%20id%3D%22lingo-sub-522700%22%20slang%3D%22en-US%22%3EHow%20to%20delete%20cell%2C%20if%20there%20is%20no%20%22Delete%22%20command%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-522700%22%20slang%3D%22en-US%22%3E%3CP%3EPopup%20menu%20does%20not%20show%20%22Delete%22%20command%20to%20delete%20single%20cell%20with%20range%20shifting.%20I%20only%20see%20%22Delete%20row%22.%20At%20the%20same%20time%20%22Delete%22%20for%20single%20cell%20is%20available%20on%20the%20other%20pages%20of%20workbook.%20What%20is%20the%20reason%20of%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-522700%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-522941%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20cell%2C%20if%20there%20is%20no%20%22Delete%22%20command%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-522941%22%20slang%3D%22en-US%22%3EI%20also%20do%20not%20know%20the%20reason.%20Meanwhile%2C%20you%20may%20use%20this%20shortcut%20to%20delete%20a%20single%20cell%20and%20shift%20cells%20up%3A%3CBR%20%2F%3ECtrl%2B%2B%2CU%2CEnter.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-525371%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20cell%2C%20if%20there%20is%20no%20%22Delete%22%20command%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-525371%22%20slang%3D%22en-US%22%3EThe%20reason%20was%20filter!%20If%20it%20exist%2C%20no%20cell%20delete%20possible%2C%20only%20row%2C%20on%20entire%20worksheet.%3C%2FLINGO-BODY%3E
bvvskype18
New Contributor

Popup menu does not show "Delete" command to delete single cell with range shifting. I only see "Delete row". At the same time "Delete" for single cell is available on the other pages of workbook. What is the reason of this?

2 Replies
I also do not know the reason. Meanwhile, you may use this shortcut to delete a single cell and shift cells up:
Ctrl++,U,Enter.
The reason was filter! If it exist, no cell delete possible, only row, on entire worksheet.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies