03/10/2025
1. β¨οΈ Ctrl + Arrow Key β Navigate quickly to the end of data β©
2. β¨οΈ Ctrl + Shift + Arrow Key β Select data range π
3. β¨οΈ Ctrl + Page Up/Page Down β Switch between worksheets π
4. β¨οΈ Ctrl + ` (Grave Accent) β Show formulas in cells π
5. β¨οΈ Ctrl + Shift + β+β β Insert new cell, row, or column β
6. β¨οΈ Ctrl + β-β β Delete selected cell, row, or column β
7. β¨οΈ Ctrl + 9 β Hide selected row π
8. β¨οΈ Ctrl + 0 β Hide selected column π
9. β¨οΈ Ctrl + Shift + ( β Unhide hidden rows π
10. β¨οΈ Ctrl + Shift + ) β Unhide hidden columns π
11. β¨οΈ Alt + = β Insert AutoSum β
12. β¨οΈ F2 β Edit active cell βοΈ
13. β¨οΈ Shift + Space β Select entire row π
14. β¨οΈ Ctrl + Space β Select entire column π
15. β¨οΈ Ctrl + Shift + L β Toggle filter on/off π
16. β¨οΈ Ctrl + ; β Insert current date π
17. β¨οΈ Ctrl + Shift + : β Insert current time β°
18. β¨οΈ Ctrl + 1 β Open Format Cells dialog βοΈ
19. β¨οΈ Ctrl + K β Insert hyperlink π
20. β¨οΈ Ctrl + Shift + β β Copy value from the cell above π
21. β¨οΈ Ctrl + D β Copy above cell down β¬οΈ
22. β¨οΈ Ctrl + R β Copy left cell to the right β‘οΈ
23. β¨οΈ Alt + Enter β Add a new line in same cell β©οΈ
24. β¨οΈ F4 β Toggle absolute/relative reference ($) π
25. β¨οΈ Shift + F11 β Insert new worksheet π
26. β¨οΈ Ctrl + Tab β Switch between Excel windows π
27. β¨οΈ Ctrl + Shift + Tab β Go back to previous window β¬
οΈ
28. β¨οΈ Ctrl + Shift + $ β Apply Currency format π΅
29. β¨οΈ Ctrl + Shift + % β Apply Percent format %
30. β¨οΈ Ctrl + Shift + # β Apply Date format π
31. β¨οΈ Ctrl + Shift + @ β Apply Time format π
32. β¨οΈ Ctrl + Shift + ^ β Apply Scientific format π¬
33. β¨οΈ Ctrl + Shift + ! β Apply Number format π’
34. β¨οΈ Ctrl + Alt + V β Open Paste Special πβ¨
35. β¨οΈ Ctrl + Shift + U β Expand/Collapse formula bar π
36. β¨οΈ Ctrl + Q β Open Quick Analysis β‘
37. β¨οΈ Alt + H + O + I β AutoFit column width π
38. β¨οΈ Alt + H + O + A β AutoFit row height π
39. β¨οΈ Alt + H + M + C β Merge & Center cells π¦
40. β¨οΈ Alt + H + B β Apply cell borders πΌ
41. β¨οΈ Alt + H + F + C β Change font color π¨
42. β¨οΈ Alt + A + T β Text to Columns βοΈ
43. β¨οΈ Alt + N + V β Insert Pivot Table π
44. β¨οΈ Alt + N + C β Insert Column Chart π
45. β¨οΈ Alt + M + R β Show Recent functions π
46. β¨οΈ Alt + M + F β Open Insert Function dialog βοΈ
47. β¨οΈ Ctrl + Shift + β/β β Select multiple rows at once β¬οΈβ¬οΈ
48. β¨οΈ Ctrl + Shift + Tab β Switch to another workbook tab π
49. β¨οΈ Ctrl + Alt + F9 β Recalculate all formulas π
50. β¨οΈ Esc β Cancel current edit or command β
