Basic Navigation1. Ctrl + Arrow Key– Jump to edge of data region
2. Ctrl + Home – Go to cell A1
3. Ctrl + End– Go to last used cell
4. Home – Go to beginning of row
5. Page Up/Page Down** – Scroll one screen up/down
6. Alt + Page Up/Page Down** – Scroll one screen left/right
7. Ctrl + G / F5** – Go to a specific cell
---
Cell Editing8. F2 – Edit selected cell
9. Ctrl + Z / Y** – Undo / Redo
10.Ctrl + C / X / V** – Copy / Cut / Paste
11. Ctrl + D** – Fill down
12. Ctrl + R** – Fill right
13. Alt + Enter** – Insert line break in a cell
14. Ctrl + “ (quote)** – Copy value from cell above
15. Ctrl + ’ (apostrophe)** – Copy formula from cell above
16. Ctrl + ;** – Insert today’s date
17. Ctrl + Shift + :** – Insert current time
---
Selection Tricks18. **Ctrl + Space** – Select entire column
19. **Shift + Space** – Select entire row
20. **Ctrl + Shift + Arrow Key** – Select to edge of data region
21. **Shift + Arrow Key** – Expand selection by one cell
22. **Ctrl + A** – Select all / current data region
23. **Ctrl + Shift + End/Home** – Select to last/first cell
---
### 
**Formatting Like a Boss**
**Formatting Like a Boss**24. **Ctrl + 1** – Format cells dialog
25. **Ctrl + B / I / U** – Bold / Italic / Underline
26. **Alt + H + O + I** – Auto-fit column width
27. **Ctrl + Shift + $** – Currency format
28. **Ctrl + Shift + %** – Percentage format
29. **Ctrl + Shift + #** – Date format
30. **Ctrl + Shift + @** – Time format
31. **Ctrl + Shift + ^** – Scientific format
32. **Ctrl + Shift + !** – Number format
33. **Alt + E + S + V** – Paste special values
---
### 
**Data Management**
**Data Management**34. **Ctrl + T** – Create table
35. **Alt + A + T** – Filter data
36. **Alt + D + F + F** – Remove duplicates
37. **Alt + E + A + A** – Clear all
38. **Ctrl + ;** – Insert date
39. **Alt + =** – AutoSum
40. **F4** – Repeat last action
41. **Ctrl + Shift + L** – Toggle filters
42. **Ctrl + K** – Insert hyperlink
43. **Ctrl + 9 / 0** – Hide row / column
44. **Ctrl + Shift + ( / )** – Unhide rows / columns
Formulas & Functions45. =SUM(...)** – Quick sum
46. =AVERAGE(...)** – Average values
47. =IF(...)** – Logic check
48. =VLOOKUP(...)** – Search vertically
49. =HLOOKUP(...)** – Search horizontally
50. =INDEX(...) + MATCH(...)** – Advanced lookup
51. Ctrl + ` – Show/hide formulas
52. Shift+ F9** – Calculate active worksheet
53. F9 – Calculate formulas manually
---
### 
**Mouse-Free Workflow**
**Mouse-Free Workflow**54. **Alt** – Activates Ribbon (keyboard access to menu)
55. **Alt + F + X** – Exit Excel
56. **Alt + F + S** – Save
57. **Alt + F + A** – Save As
58. **Ctrl + N** – New workbook
59. **Ctrl + O** – Open workbook
60. **Ctrl + P** – Print dialog
