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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I enable 'insert copied cells' (option not available in men (https://www.excelbanter.com/excel-discussion-misc-queries/90224-how-do-i-enable-insert-copied-cells-option-not-available-men.html)

Excel Amateur

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

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?

Ardus Petus

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

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

"Excel Amateur" <Excel a écrit dans le
message de news: ...
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?

All times are GMT +1. The time now is 04:56 PM.