Register now or log in to join your professional community.
I Use This CTRL + ALT + V , Then I Click V Then Enter ,
If you came here looking for an easy short-cut key to paste values in Excel then it's bad news I'm afraid - there just isn't a simple keyboard shortcut in the same way there is to cut, copy or paste normally. However there is a way to paste values using the keyboard, which this tip shares with you.
ALT+E Than S than V
Alt+E+S+V and then Enter
Alt+e, S ->V
This is not "Short" cut, this opens edit menu then goes to paste special command and pastes value,
it makes it by keyboard instead of mouse
ctrl+c for copy and
ctrl+v for Paste
For Pasting only the Value of the copied cells
Alt+E,s,v,enter
For old version i.e. Office2003, alt + e ,s + v
for2007 or later, we can use QUICK ACCESS TOOLBAR at top, and may use ALT + (index of shortcut at toolbar).
Alt+E+S,V
Ctrl+V
Alt >> H >> V >> V