Thursday, October 13, 2011

[Trick] Microsoft Excel - Copy, Cut, Paste and Paste feature Disabled


Issue


How to solve the issue when your Microsoft Excel’s Copy, Cut, Paste and Paste Special feature are disabled?

Answer

Troubleshooting steps:

1. Open MS Excel
2. Press Alt + F11 to get into Microsoft Visual Basic



3. Go to View and select Immediate Window or you can Press Ctrl + G, immediate window will pop up.


4. Type common application.commandbars("cell").reset and press Enter:

 

5. Then go back to Ms Excel and test it. The Copy, Cut, Paste and Paste Special feature are available.
     You can close the MS Visual Basic.


  

No comments: