Thursday, August 23, 2007

Key board Shorkut's in Excel!!!

Keyboard Shortcuts Result in Excel - Formulas
ALT and = Autosum
ALT and F8 Macros
CTRL and ; Insert Current Date
CTRL and : Insert Current Time

Keyboard Shortcuts Result in Excel - Movement
Left Arrow One Cell Left (also SHIFT and TAB)
Right Arrow One Cell Right (also TAB)
Up Arrow One Cell Up
Down Arrow One Cell Down
Home Go to End of row
CTRL and left Arrow Go to End of Column
CTRL and Home Go to Top of Worksheet (A1)
CTRL and End Go to End of Worksheet
CTRL and PAGE-DOWN Go to Next Worksheet

Keyboard Shortcuts Result in Excel - Cell Selection
CTRL and Spacebar Select the entire Column
SHIFT and Spacebar Select the entire Row
CTRL and A Select Entire Worksheet
SHIFT and Left Cursor Select all cells to the left of the active one
SHIFT and Right Cursor Select all cells to the right of the active one..




Love happen's once and the rest is just life!!!!

1 comment:

Silent Singer said...

thanks for ur tips on excel.

>