How to Fix Error Cannot Copy Data in Excel Files

This practical guide walks through how to fix error cannot copy data in Excel files, explains the main requirements, and highlights common issues that may appear along the way.

How to fix an error that cannot copy data in an Excel file In Excel, when you use the Ctrl C button, you cannot copy the data, your Excel (Office) software suite may have an error. To fix this error, you need to edit the copy shortcut through Word software. Here are the steps we want to guide you through.

Step 1: Select File> Options> Customize Ribbon> Customize

In the Word window, click File on the horizontal toolbar. Next, click on Options at the bottom.

Then the Options window box will appear on the screen. Switch to the Customize Ribbon tab and click Customize at the bottom of the Keyboard shortcuts.

Step 2: Edit the error in the Customize Keyboard section

Then the Customize Keyboard panel will appear so you can edit the function of using Office keyboard shortcuts. Copy function of Office located in the Home Tab of Categories and in the EditCopy section of Commands.

Users can search for their names based on alphabetical order.

When selecting this function, if you see that in Current keys below there is no Ctrl C, this is probably the non-copy error that you have encountered.

Then to correct the error, you click on the box Press new shortcut key.

Then you can press Ctrl C to assign a copy shortcut or any shortcut for the copy function you want.

Then you click on the Assign at the bottom to add. Please see the image below for better understanding.

With the above 2 simple steps, you can read and edit errors that cannot be copied in Excel. Hope this article will be useful to you in the working process.

Good luck!