Cut, Copy and Paste greyed out in Excel

February 23, 2011 by Chris Ainger 3 Comments


Keyboard shortcuts Ctrl+X, Ctrl+C and Ctrl+V work fine, but you find that the above options are grayed out, try the following methods, one should help you out:

Method 1:
Open excel
hit alt-f11 – This opens the VB editor
hit ctrl-g – This opens the area for the current window

Type this and hit enter:
application.commandbars(“cell”).reset

Click Play

Method 2:
Close Excel
Go to C:\Users\username\AppData\Roaming\Microsoft\Excel
Rename Excel11.XLB
Open Excel

This will return the option now when you right-click again

I think it might be part of the formatting or coding in the workbooks that knocks out the options.

Hope this helps

Computer Stuff, Office 2003
Chris Ainger's avatar

About Chris Ainger

View all posts by Chris Ainger →

3 Responses to “Cut, Copy and Paste greyed out in Excel”

  1. Unknown's avatar
    Manoj Sharma Reply July 3, 2015 at 11:07 am

    Excellent .It work Thanks a Lot

  2. Unknown's avatar
    Kumar Krishnendu Bhattacharya Reply August 31, 2015 at 3:50 am

    Method 2 worked for me..Thanks a ton 🙂

  3. Unknown's avatar
    PRASAD Reply December 23, 2015 at 4:42 am

    Thaanx a lot it worked out!

Leave a reply to Kumar Krishnendu Bhattacharya Cancel reply