Navigation Shortcuts

1. Move between cells: Arrow keys (Up, Down, Left, Right) 2. Go to the edge of data region: Ctrl + Arrow keys 3. Jump to the beginning or end of a row/column: Home/End key

Click Here 

Arrow

Selection Shortcuts

– Select entire row: Shift + Space – Select entire column: Ctrl + Space – Select the entire worksheet: Ctrl + A

Click Here 

Arrow

Data Entry Shortcuts

– Enter data and move down: Enter – Enter data and move right: Tab – Edit cell: F2 – AutoSum selected cells: Alt + = – Fill down: Ctrl + D – Fill right: Ctrl + R

Click Here 

Arrow

Managing Sheets

– Insert new sheet: Shift + F11 – Switch between sheets: Ctrl + Page Up/Page Down – Rename sheet: Alt + H, O, R

Arrow

Working with Formulas

– Start a formula: = (equals sign) – AutoComplete formula: Tab – Insert function: Shift + F3 – Evaluate formula: Alt + M, V – Trace precedents: Ctrl + [ – Trace dependents: Ctrl + ]