Cannot copy and Insert Copied Cells

Question

Excel v.16.45

I used to be able to copy and Insert Copied cells where it would push the cells down and insert the copied cells. Now it inserts a blank row when it pushes the cells down. Why? What happened to this simple capability - I am frustrated so I will ask, is MS thinking about their long time users before deciding on engineering changes that make no sense?

And how do you get support with Microsoft? We pay for O365 and all we get is forum help??

Answer 1

Hi Demetris,

We are so sorry for your inconvenience it has caused. And we will try our best to help you if we can do something.

Based on your problem, we tested it on our end, and it works well. Here is my test result for your reference.

So, to help you troubleshoot further, we sincerely suggest that you can try the suggestions below.

1. You can start Mac in safe mode and open Excel application to isolate the problem is related to other programs on your Mac.
2. If the suggestion above doesn’t work, we would like to suggest removing the Excel cache and configuration file from the Library folder.

a. Completely quit all Office applications.

b. In Finder, press Command +Shift + G and enter ~/Libraryto open the Library folder.

c. In the Library folder, if your macOS is Big Sur, open Containers folder and remove the folder “Microsoft.Excel”. If your macOS isn’t Big Sur,****open Containers folder and remove the folder “com.microsoft.excel”.

d. Restart Mac and relaunch Excel application to see the results.

3. Create a new user profileto perform a clean new environment to start Mac again to isolate the system impact.

However, if the problem persists, could you please provide some information for us to troubleshoot further so that we can provide more targeted suggestions for you?

1. The screenshot of your macOS.
2. A video of the problem. You can remove the personal information and upload it to OneDrive, and then share the video link with us to access it: Share files in OneDrive.
3. Does the problem happen to all Excel workbooks or just a specific one?

Hope this can help you. 😊 Have a good day.

Best regards,

Cindy

Answer 2

Hi Demetris,

If you have any confusion, welcome to share any updates when you have time if you need further help on this issue.

Best regards,

Cindy