Cut, Copy and Paste greyed out in Excel


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

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

  1. Excellent .It work Thanks a Lot

  2. Kumar Krishnendu Bhattacharya Reply August 31, 2015 at 3:50 am

    Method 2 worked for me..Thanks a ton 🙂

  3. Thaanx a lot it worked out!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: