Copy – Paste : Most frequently
done !! Let us now learn to do it smartly J
What we already know :
Copy : Ctrl+C
Paste : Ctrl+V
What we should also know!!
Paste Special :
Alt + E + S + V : Copy Values without the existing format
Alt + E + S + T : Copy formatting
Alt + E + S + F : Paste Formula
Alt + E + S + W : Paste Column Width
Alt + E + S + C : Paste Comments
Only
Alt + E + S + D : Paste addition of copied cell with
existing cell
Alt + E + S + S : Paste subtraction of copied cell with existing cell
ALT + E + S + M : Paste multiplication of copied cell with existing cell
ALT + E + S + I : Paste division of copied cell with existing cell
ALT + E + S + E : Transpose
data/ Convert Rows into columns and columns into rows
No comments:
Post a Comment