ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Edit Delete Cell missing (https://www.excelbanter.com/excel-discussion-misc-queries/159113-edit-delete-cell-missing.html)

GrahamCDouglas

Edit Delete Cell missing
 
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

Edit Delete Cell missing
 
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.



GrahamCDouglas

Edit Delete Cell missing
 
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.




Bob I

Edit Delete Cell missing
 
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.





GrahamCDouglas

Edit Delete Cell missing
 
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.





Bob I

Edit Delete Cell missing
 
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.






All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com