How do I enable 'insert copied cells' (option not available in men

E

Excel Amateur

When I cut data and want to paste the cells in another section, the option is
unavailable on the drop down menu. What can I do to rectify this, please?
 
A

Ardus Petus

In VBE immediate window (from Excel: Alt+F11 then Ctrl-g), type:
commandbars("Cell").Reset

Get back to Excel and try your contextual menu.

HTH
 
Top