[Fixed!] CTRL C Not Working in Excel

Get FREE Advanced Excel Exercises with Solutions!

CTRL + C ย or CTRL C, a widely used keyboard shortcut, is utilized for copying text or anything to the clipboard. Later, you can paste the copied things to your desired space. Unfortunately, due to some reasons in some cases, this handy shortcut might not work in Excel. Did you ever face such a tiresome situation? In this article, we have given 6 workable solutions for CTRL C not working In Excel.


Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.


Reasons for CTRL C Not Working in Excel

Notable reasons for CTRL C not working in Excel include:

  • Hardware problem that creates the issue.
  • The keyboard can malfunction so that CTRL C does not work in Excel.
  • The Excel you are using may be affected by the virus, so CTRL C is not working in Excel.
  • The Excel file can be corrupted.

8 Possible Solutions If Keyboard Function with CTRL C Is Not Working in Excel

In this section, youโ€™ll explore eight effective workarounds you have trouble using the CTRL C keyboard shortcut is not working in Excel.

1. Enable Excel Clipboard Shortcut

Excel Clipboard Shortcut is an amazing process of copying a cell or entire cell. When CTRL C is not working in Excel, you can use the Excel Clipboard Shortcut. Follow the steps below.

๐Ÿ“Œ Steps:

  • Go to the Home tab >> click on the corner icon of Clipboard >> click on the Options >> select Show Office Clipboard When Ctrl + C Pressed Twice.

Enable Clipboard Shortcut

  • Secondly, select the cell that you want to copy. For example, here we select cell B5. It will appear on the clipboard as shown in the screenshot.

Enable Excel Clipboard Shortcut

  • Finally, we select the word of the Clipboard and paste it wherever we want to paste it. Here, we paste it into a cell.

Read More: [Fixed!] Excel Links Not Working Unless Source Workbook Is Open


2. Utilizing Context Menu

You can use the computerโ€™s built-in context menu instead of using the CTRL C.

๐Ÿ“Œ Steps:

  • Firstly, select the cell that you want to copy.
  • Then, right-click on it. A context menu will pop out.
  • Select Copy. So you can copy the text without CTRL C.

Utilizing Context Menu

Read More: How to Show Menu Bar in Excel (2 Common Cases)ย 


3. Enable CTRL C in Command Prompt and PowerShell

If CTRL C is not working in Excel, you can enable windows command prompt or PowerShell.

๐Ÿ“Œ Steps:

  • Firstly, open the RUN function by pressing Windows + R. A dialog box will pop up. Write down cmd and click

Enable CTRL C in Command Prompt and PowerShell

  • After that select Properties from the Context Menu.

Enable CTRL C in Command Prompt and PowerShell

  • Check the box โ€œEnable Ctrl key shortcutsโ€ from the Options.
  • Press OK.

Enable CTRL C in Command Prompt and PowerShell

  • Close it and reopen the command so that the changes may take effect.

Read More: How to Fix Formula in Excel (9 Easy Methods)


4. Reboot the PC in Clean Boot State

However, rebooting the PC in a clean boot state will show you if the Excel sheet is corrupted or not. So, follow the steps below to do it.

๐Ÿ“Œ Steps:

  • Firstly, select the Windows icon and search for You can also do that by pressing Windows + R.
  • Then, type msconfig in the Open box and press OK.

Reboot the PC in Clean Boot State

  • As a result, a dialog box will pop up. There, under the General tab, uncheck Load startup items in the Selective startup.

Reboot the PC in Clean Boot State

  • After that, jump to Services. Here, check to Hide all Microsoft services, and select Disable all. It is shown in the screenshot for your better understanding.

Reboot the PC in Clean Boot State

  • In the Startup tab, select Open Task Manager.

  • Then disable each and every startup process.

  • Finally, go back to the System Configuration window >> press OK to save the changes. Itโ€™ll reboot in clean mode after you restart your PC.

Similar Readings


5. Enable and Disable the Excel Add-In

Add-Ins can make the Excel Sheet freeze so that CTRL C does not work in Excel. Therefore, we need to follow the steps to disable and again enable the Excel Add-In.

๐Ÿ“Œ Steps:

  • At first, Open the Excel.
  • Select FIle >> click Options.
  • Apparently, a dialog box will pop out, In the Add-ins tab, select option Go and it is beside the manage box.

Enable and Disable the Excel Add-In

  • Uncheck all the boxes to disable the Add-In.

  • After that, enable them again then the issue of CTRL C not working in excel issues will be fixed.

Read More: [Fixed!] Up and Down Arrows Not Working in Excel (8 Solutions)


6. Update the Keyboard Driver

A corrupted driver may cause an issue with CTRL C not working in Excel. You can update the driver or reinstall it to resolve the issue.

๐Ÿ“Œ Steps:

  • At first, go to Device Manager. Next, select Keyboards >> click Update Driver.

Update the Keyboard Driver

  • Lastly, if there is no update available, then reinstall the keyboard driver and use it. It will fix the CTRL C not working problem.

7. Run the Keyboard Troubleshooter

The pc troubleshooters often solve software-related problems. You need to follow the steps to RUN the keyboard troubleshooter.

๐Ÿ“Œ Steps:

  • Go to Settings >> Update & Security >> Troubleshoot >> Additional troubleshooters.

Run the Keyboard Troubleshooter

  • Subsequently, select the Keyboard and Run the troubleshooter.

Run the Keyboard Troubleshooter

  • Finally, the problem of CTRL C not working in Excel will be solved.

8. Launch Excel in Safe Mode

Sometimes damaged or corrupted Excel functions restrain you from copying the data. You can use Excel in Safe Mode to solve this.

๐Ÿ“Œ Steps:

  • Press and hold the CTRL key and open the Excel file.
  • A box will appear, Select Yes.

Launch Excel in Safe Mode


Practice Section

We have provided a practice section on each sheet on the right side for your practice. Please do it by yourself.


Conclusion

So, these are some solutions to fix CTRL C not working in Excel. Please let us know in the comment section if you have any questions or suggestions. For your better understanding please download the practice sheet. Visit our website Exceldemy to find out diverse kinds of excel methods. Thanks for your patience in reading this article.


Related Articles

Fahim Shahriyar Dipto

Fahim Shahriyar Dipto

Hello! Welcome to my Excel blog! I am a big fan of MS Excel. I am learning new and exciting things in Excel and writing the process here. I think this will be helpful for you to get used to Excel. Keep visiting our website for new and updated Excel methods.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo