Forum Discussion

bvvskype18's avatar
bvvskype18
Copper Contributor
May 03, 2019

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

  • bvvskype18's avatar
    bvvskype18
    Copper Contributor
    The reason was filter! If it exist, no cell delete possible, only row, on entire worksheet.
  • Twifoo's avatar
    Twifoo
    Silver Contributor
    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.

Resources