Saturday, August 11, 2012

Excel Short cut tips


Courtesy: http://chandoo.org/wp/2011/08/08/must-have-excel-keyboard-shortcuts/

I am a regular subscriber of Chandoo.org...and this a great excel website....

1. CTRL+1 – Format
2. CTRL+SHIFT+L – Turn on/ off filters
3. CTRL+Arrow keys – Navigate around the workbook
4. ALT+ES – Paste Special > Values
ALT+ES (press E then leave the key and press S) to paste special.
5. F4 – Change cell reference style while editing formulas
6. F2 – Edit a cell
7. F3 – Show Names
8. CTRL+K – Add Hyperlink
9. CTRL+T – Insert Table
10. CTRL+S – Save