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
Excellent .It work Thanks a Lot
Method 2 worked for me..Thanks a ton 🙂
Thaanx a lot it worked out!