Edit Delete Cell missing

's Computer Specifications

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.

's Computer Specifications

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

GrahamCDouglas wrote:

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

's Computer Specifications

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

"Bob I" wrote:

> Click Tools, Customize, then up on the Excel menu, r-click Edit and pick
> Reset.
>
> GrahamCDouglas wrote:
>
> > 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.
>
>

's Computer Specifications

You have a locked spreadsheet perhaps?

GrahamCDouglas wrote:

> Still no Edit Delete Cell. Insert Cells... is grayed out. Hmmm.
>
> "Bob I" wrote:
>
>
>>Click Tools, Customize, then up on the Excel menu, r-click Edit and pick
>>Reset.
>>
>>GrahamCDouglas wrote:
>>
>>
>>>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.
>>
>>

's Computer Specifications

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

"Bob I" wrote:

> You have a locked spreadsheet perhaps?
>
> GrahamCDouglas wrote:
>
> > Still no Edit Delete Cell. Insert Cells... is grayed out. Hmmm.
> >
> > "Bob I" wrote:
> >
> >
> >>Click Tools, Customize, then up on the Excel menu, r-click Edit and pick
> >>Reset.
> >>
> >>GrahamCDouglas wrote:
> >>
> >>
> >>>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.
> >>
> >>
>
>

's Computer Specifications

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

GrahamCDouglas wrote:

> I figured out the problem. I have grouped columns and the Edit Delete Cell is
> disabled when the group is closed.
>
> "Bob I" wrote:
>
>
>>You have a locked spreadsheet perhaps?
>>
>>GrahamCDouglas wrote:
>>
>>
>>>Still no Edit Delete Cell. Insert Cells... is grayed out. Hmmm.
>>>
>>>"Bob I" wrote:
>>>
>>>
>>>
>>>>Click Tools, Customize, then up on the Excel menu, r-click Edit and pick
>>>>Reset.
>>>>
>>>>GrahamCDouglas wrote:
>>>>
>>>>
>>>>
>>>>>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.
>>>>
>>>>
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I delete selected text? I don't see(find) an edit delete	csuu	Microsoft Word Document Management	1	29th Oct 2009 08:38 AM
Edit Delete Cell missing	=?Utf-8?B?R3JhaGFtQ0RvdWdsYXM=?=	Microsoft Excel Misc	2	20th Sep 2007 07:25 PM
DataGridView, text cell edit mode and Delete key	Richard Lewis Haggard	Microsoft Dot NET Framework Forms	1	23rd May 2007 08:39 PM
GridView edit validation, edit dropdown list, delete popup confirm	=?Utf-8?B?a2Vu?=	Microsoft ASP .NET	1	23rd Jan 2006 12:51 PM
Excel Macro to edit and delete one character in a cell	David	Microsoft Excel Programming	5	8th Dec 2004 12:02 PM