Forum Discussion
Can’t right click and paste in excel
Have you ever lost your ability to right click & paste into cells in excel? I have and don’t know how to fix it.
Lawana
10 Replies
I just purchased Microsoft Office 365 after upgrading to a new Mac laptop. I was also getting frustrated with this issue-and realize I'm late to the party :). Anyway, I looked at many message boards and could not find a fix that seemed to work.
I am not a tech person, so my non-tech answer is that I stumbled into a work around. When I've been highlighting the area I want to right click on, it hasn't been working consistently. For example, I would highlight several cells and right click and it would pop up the right click menu and then the next time it wouldn't. What I discovered is that if I highlight the area I want to right click on, THEN move my pointer away from the selected area, and then move it back to the selected area and right click, it works! Moving the pointer into the selected area and right clicking also works. This wasn't something I had to do in past versions of excel. shrug. Hope this helps someone.
Jessica7777 Thanks for that idea, I will try when mine next plays up! and report back -Have a nice day!
To be able to reuse them, open the affected workbook in Excel and press the "Alt" and "F11" keys on your keyboard at the same time.
A new window will open, press the "Ctrl" or "Ctrl" and "G" keys.
Enter the following command in the opened window below (you can simply copy it):
Application.CommandBars("Cell").Enabled = TrueConfirm with Enter and then press the "Alt" and "Q" keys to close the window.
The right mouse button should work now :).
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
wow NikolinoDE
It worked, I didn't even understand what it meant, just blindly input what you suggested! thanks v much!
- I'm glad it helped you.
Furthermore, I wish you much success with Excel.
