Featured Post

VLOOKUP or INDEX MATCH.. Which one is better?

In the office, my co-worker told me he couldn't get state of Ranking 1 by using VLOOKUP. I recommended INDEX and MATCH combination func...

Wednesday, August 17, 2016

Let's use short cut keys when you use copy and paste....

We use copy and paste short cut keys many times.
Yet, keep practicing when you are in the office...

Excel 2007

Values : Ctrl+C -> select a cell if you want to paste -> Alt+E ->S ->V-> Enter
Formulas : Ctrl+C -> select a cell if you want to paste -> Alt+E ->S ->F-> Enter 

Formats :  Ctrl+C -> select a cell if you want to paste -> Alt+E ->S ->T-> Enter
 
Excel 2003 


Values : Ctrl+C -> select a cell if you want to paste -> Alt+S ->V-> Enter
Formulas : Ctrl+C -> select a cell if you want to paste -> Alt+S->F-> Enter 
Formats :  Ctrl+C -> select a cell if you want to paste -> Alt+S->T-> Enter

No comments:

Post a Comment