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.
- 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.
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.
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
- 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.
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.
- 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.
Similar Readings
- How to Remove Last Modified By in Excel (3 Ways)
- If a Value Lies Between Two Numbers Then Return Expected Output in Excel
- How to Create Butterfly Chart in Excel (2 Easy Methods)
- How to Move Up and Down in Excel (5 Easy Methods)
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.
- 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.
- 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.
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
- How to Calculate Root Mean Square Error in Excel
- Make a Modified Box Plot in Excel (Create and Analyze)
- How to Do Descriptive Statistics in Excel (2 Suitable Methods)
- Make Trial Balance in Excel (with Easy Steps)
- How to Get Summary Statistics in Excel (7 Easy Methods)
- Make Fishbone Diagram in Excel (with Easy Steps)
- How to Make a Dot Plot in Excel (3 Easy Ways)