Thursday, October 24, 2013


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 + 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