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.
If CTRL C Not Working in Excel: 4 Major Reasons
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.
CTRL C Not Working in Excel: 8 Possible Solutions
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.
- 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.
- Finally, we select the word of the Clipboard and paste it wherever we want to paste it. Here, we paste it into a cell.
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.
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 OK.
- After that select Properties from the Context Menu.
- Check the box “Enable Ctrl key shortcuts” from the Options.
- Press OK.
- Close it and reopen the command so that the changes may take effect.
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.
- As a result, a dialog box will pop up. There, under the General tab, uncheck Load startup items in the Selective startup.
- 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.
- 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.
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 file.
- 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.
- 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.
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:
- First, go to Device Manager. Next, select Keyboards >> click Update 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.
- Subsequently, select the Keyboard and Run the 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.
Download Practice Workbook
Download the following practice workbook. It will help you to realize the topic more clearly.
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.
Related Articles
- [Solved] Excel Copy Paste Loses Formatting
- [Fixed!] Cannot Copy Merged Cells in Excel
- [Fixed]: Right Click Copy and Paste Not Working in Excel
- [Fixed!] Paste Link Not Working in Excel
- [Fixed!] Copy and Paste Not Working Between Workbooks in Excel
- How to Copy Number Not Formula in Excel
- [Fixed!]: Microsoft Excel Cannot Paste the Data as Picture