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

Copper 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.