Deleting Cells Option doesn't appear

[Guest]

I have a workbook with several tabs. Each sheet has command buttons and
macros -- but the format is identical.

I want to delete a few cells (not rows, just cells)
On some of the tabs, I can select the cells, Edit / Delete / Shift Up
However, on some of the tabs, I can select the cells and I only get the
option to "Delete Row". I have compared the Options and other settings, and
can't find what would be doing this.

Any ideas

 

[Guest]

Nevermind -- I finally found it -- I had a Filter that was on. Apparently,
even if the filter is not in the area that you want to delete, it still
disables the delete cells option for the entire sheet.

Thanks