Forum Discussion
bvvskype18
May 03, 2019Copper Contributor
How to delete cell, if there is no "Delete" command?
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
- bvvskype18Copper ContributorThe reason was filter! If it exist, no cell delete possible, only row, on entire worksheet.
- TwifooSilver ContributorI also do not know the reason. Meanwhile, you may use this shortcut to delete a single cell and shift cells up:
Ctrl++,U,Enter.