Insert Copied Cells

Question

Insert Copied Cells

Jason Peller 0

Excel will not allow the function "Insert Copied Cells", reviewed all existing fixes, reinstalled, nothing works. Open a brand new Worksheet type in basic data and try Copy > Insert Copied Cells and it is greyed out with no option. I can insert full rows, but I cannot copy and then insert the copied data elsewhere.

0 comments

Answer accepted by question author

Demi-N 16,510 Microsoft External Staff Moderator

Hello @Jason Peller,

Thank you for your message.

To better understand what might be causing this behavior, I would like to gather a bit more detail about your scenario so I can try to reproduce it on my side.

Could you please let me know what type of range you are copying from? For example, is it a single cell, a full row/column, or a selected range of multiple cells? Also, is your data part of an Excel table, or just a normal worksheet range?

If possible, it would be very helpful if you could share a screenshot showing the “Insert Copied Cells” option greyed out. This will allow me to see exactly what you are encountering.

Additionally, if you could briefly describe how your data is structured (for example, whether there are merged cells or any special formatting), that would help me narrow things down even further.

With a bit more information, I’ll be able to better reproduce the issue and provide more precise guidance.

Thank you for your time, and I look forward to your reply.

Kind regards,

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Jason Peller 0 Reputation points

2026-05-19T17:30:09.0966667+00:00

New workbook, just trying as a test to copy 4 cells and then insert copied cells, option is grey. There is no formatting to the sheet, no filters, no protection.
Jason Peller 0 Reputation points

2026-05-19T17:32:26.2033333+00:00

Odd thing is that if I right click and click under "Search the Menus" I type insert and then it gives me the option to Insert Copied Cells
Jason Peller 0 Reputation points

2026-05-19T17:32:59.5633333+00:00

But this is not an efficient process for when I need to work with sheets to always have to search for Insert to perform this task.
Demi-N 16,510 Reputation points Microsoft External Staff Moderator

2026-05-20T14:21:56.4166667+00:00
Hi @Jason Peller,

Thank you for the additional details and screenshots. Your observation about the "Search the Menus" feature is very helpful.

I’ve tested the same scenario with a new workbook on my side, and the "Insert Copied Cells" option works normally.

As this appears specific to your environment, please try the steps below:

1. Run Excel in Safe Mode

Close Excel, then hold the Ctrl key while reopening it and confirm Safe Mode. Test the right-click option in a blank sheet. If it works normally here, a third-party add-in can be related and can be safely disabled:

Open Excel normally.

File > Go to Options > Add-ins.

At the bottom, select COM Add-ons and click Go.

Temporarily disable all add-ins, restart Excel, and test again.

2. Reset the Excel Menu Configuration File

Close Excel, press Windows + R, type %appdata%\Microsoft\Excel, and press Enter. Locate any .xlb file (e.g., Excel15.xlb) and delete or rename it. Excel will recreate it on next launch.

3. Perform an Online Repair

Please follow this guide: Repair an Office application - Microsoft Support

Choose the “Online Repair” option to fully refresh Office components.

Thank you again for your cooperation. I look forward to hearing about the results.

Best regards,
Jason Peller 0 Reputation points

2026-05-20T14:34:06.8666667+00:00

Amazing, Step 2 worked and I see the Insert Copied Cells now. Thank you!
Demi-N 16,510 Reputation points Microsoft External Staff Moderator

2026-05-20T15:03:04.06+00:00

Hi @Jason Peller,

Thank you for your update. I’m very glad to hear that your issue has been resolved.

If you found my answer helpful, please click "Accepted". This helps others with similar questions quickly find the solution.

Thank you again for your cooperation and support!

1 additional answer

Your answer

Jason Peller 0 Reputation points

2026-05-19T17:30:09.0966667+00:00

New workbook, just trying as a test to copy 4 cells and then insert copied cells, option is grey. There is no formatting to the sheet, no filters, no protection.
Jason Peller 0 Reputation points

2026-05-19T17:32:26.2033333+00:00

Odd thing is that if I right click and click under "Search the Menus" I type insert and then it gives me the option to Insert Copied Cells
Jason Peller 0 Reputation points

2026-05-19T17:32:59.5633333+00:00

But this is not an efficient process for when I need to work with sheets to always have to search for Insert to perform this task.
Demi-N 16,510 Reputation points Microsoft External Staff Moderator

2026-05-20T14:21:56.4166667+00:00

Hi @Jason Peller,

Thank you for the additional details and screenshots. Your observation about the "Search the Menus" feature is very helpful.

I’ve tested the same scenario with a new workbook on my side, and the "Insert Copied Cells" option works normally.

As this appears specific to your environment, please try the steps below:

1. Run Excel in Safe Mode

Close Excel, then hold the Ctrl key while reopening it and confirm Safe Mode. Test the right-click option in a blank sheet. If it works normally here, a third-party add-in can be related and can be safely disabled:

Open Excel normally.

File > Go to Options > Add-ins.

At the bottom, select COM Add-ons and click Go.

Temporarily disable all add-ins, restart Excel, and test again.

2. Reset the Excel Menu Configuration File

Close Excel, press Windows + R, type %appdata%\Microsoft\Excel, and press Enter. Locate any .xlb file (e.g., Excel15.xlb) and delete or rename it. Excel will recreate it on next launch.

3. Perform an Online Repair

Please follow this guide: Repair an Office application - Microsoft Support

Choose the “Online Repair” option to fully refresh Office components.

Thank you again for your cooperation. I look forward to hearing about the results.

Best regards,
Jason Peller 0 Reputation points

2026-05-20T14:34:06.8666667+00:00

Amazing, Step 2 worked and I see the Insert Copied Cells now. Thank you!
Demi-N 16,510 Reputation points Microsoft External Staff Moderator

2026-05-20T15:03:04.06+00:00

Hi @Jason Peller,

Thank you for your update. I’m very glad to hear that your issue has been resolved.

If you found my answer helpful, please click "Accepted". This helps others with similar questions quickly find the solution.

Thank you again for your cooperation and support!

Answer 1

AI answer

In Excel, the Insert Copied Cells command is only enabled when there is an active copy or cut selection and a valid target cell/row/column is selected. If it is greyed out even in a new workbook, use the command sequence explicitly as documented:

Select the cell, row, or column that should be copied.
On the Home tab, in the Clipboard group, select Copy (or press CTRL+C).
Now select the row or column below or to the right of where the copied content should be inserted.
Right‑click that row/column header and choose Insert Copied Cells.

Key points based on this behavior:

The command appears on the right‑click menu of the destination row/column header, not on the source.
It only becomes available after a successful Copy (or Cut) operation; if the copy operation is cancelled (for example, by pressing Esc or performing another action that clears the clipboard), Insert Copied Cells will be disabled.
Excel indicates a valid copy/cut selection with an animated moving border around the source cells; if that border is not visible, copy again before trying Insert Copied Cells.

If copy/paste itself works (as in this case) and the above sequence is followed, Insert Copied Cells should be available for inserting the copied rows/columns.

References:

AI-generated content may be incorrect. Read our transparency notes for more information.

Share via

Insert Copied Cells

1 additional answer

Your answer