Edit Delete Cell missing

[Guest]

Edit Delete of a Cell is missing from my Edit menu. The Edit menu is fully
extended and I checked Options to see if there was a setting I could adjust.
I need to delete a cell and Shift Left. I've done this before.

 

[Bob I]

Click Tools, Customize, then up on the Excel menu, r-click Edit and pick
Reset.

 

[Guest]

Still no Edit Delete Cell. Insert Cells... is grayed out. Hmmm.

 

[Bob I]

You have a locked spreadsheet perhaps?

Still no Edit Delete Cell. Insert Cells... is grayed out. Hmmm.

:

 

[Guest]

I figured out the problem. I have grouped columns and the Edit Delete Cell is
disabled when the group is closed.

 

[Bob I]

Thank you for posting back with the solution so others may benefit!