how to fix error cannot copy data in Excel files

Although they know the cause, not everyone knows how to fix the failure to copy it. Here, TipsMake will guide you how to quickly fix the error of not being able to copy data in Excel file

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.

how to fix error cannot copy data in Excel files Picture 1

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.

how to fix error cannot copy data in Excel files Picture 2

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.

how to fix error cannot copy data in Excel files Picture 3

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.

how to fix error cannot copy data in Excel files Picture 4

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!

4 ★ | 1 Vote

May be interested

  • How to fix the error can not open Excel filesHow to fix the error can not open Excel files
    how to fix the error can not open excel files. download the excel file online or copy the excel file from your friend's computer to your computer. but when opening, it cannot open, you are not sure how to fix the error of not opening exce file
  • What is ### error in Excel? how to fix ### error in ExcelWhat is ### error in Excel? how to fix ### error in Excel
    ### in excel is an error that excel frequently encounters and appears in many different cases when we enter data in excel, functions in excel, enter formulas in excel or when displaying results.
  • Instructions to copy data from Excel to Word retain the formatInstructions to copy data from Excel to Word retain the format
    sometimes at work you want to convert table data from excel to word, but when the copy to word is formatted or exceeds the frame in the word. the following article details how to copy data from excel to word to keep the format.
  • Fix error of Copy Paste command not working in Word, Excel (2007, 2010)Fix error of Copy Paste command not working in Word, Excel (2007, 2010)
    there are many causes of the copy paste command error that do not work on windows computers, such as your computer being attacked by viruses, the clipboard does not work, and so the copy (ctrl + c) and paste commands ( ctrl + v) does not work. so how to fix this error, please refer to the following article of network administrator.
  • How to copy files larger than 4GB to USBHow to copy files larger than 4GB to USB
    how to copy files larger than 4gb to usb. how if our usb can not copy files larger than 4gb and error. this is a very basic problem on usb when we store. this problem arises from the format of usb. in this article, the software tips will guide you how to copy files larger than 4gb into usb.
  • How to copy sheet from Excel file to another Excel fileHow to copy sheet from Excel file to another Excel file
    while working with excel, there are times when you want to copy the sheet from one excel file to another excel file to facilitate data processing. if you do not know how to copy sheet, please refer to how to copy sheet in excel to other excel file in this article.
  • How to link, link data between Excel filesHow to link, link data between Excel files
    when using excel, there are cases where the data resides in different excel files, and you need to get data from one excel spreadsheet to another. so you have to create data links between excel files so that data can be transferred automatically.
  • 4 Fastest Ways to Copy Files in Windows4 Fastest Ways to Copy Files in Windows
    copying files in windows is a familiar operation, but not everyone knows how to optimize to copy data faster. with large files, you may encounter slowness, file too large errors or interruptions. let's learn with free download how to copy files effectively, from shortcuts, and robocopy.
  • 10 ways to recover corrupted Excel files10 ways to recover corrupted Excel files
    here are 10 simple ways to recover files, excel spreadsheets are corrupted before considering ... crying or reworking from the beginning.
  • How to simply copy files from computer to iPhone / iPadHow to simply copy files from computer to iPhone / iPad
    when copying data from computer to iphone device (not jailbreak) via itunes tool, we can only apply to image and video files, and other files like doc, xls, and pdf are not. today, we will share with you two small applications, called documents and playerxtreme media player, in which documents can help you freely copy all different file types to iphone, playerxtreme media player help transfer media files from computer to iphone without plugging in the cord or itunes.