1.
File and Workbook Operations
1. Ctrl + N – New Workbook
2. Ctrl + O – Open Workbook
3. Ctrl + S – Save Workbook
4. F12 – Save As
5. Ctrl + P – Print
6. Ctrl + W – Close Workbook
7. Alt + F4 – Close Excel
8. Ctrl + Z – Undo
9. Ctrl + Y – Redo
2. Navigation and Selection
10. Arrow Keys – Move One Cell
11. Ctrl + Arrow Keys – Jump to Edge of Data
12. Shift + Arrow Keys – Select Cells
13. Ctrl + Shift + Arrow Keys – Select Range to Edge
14. Ctrl + Home – Go to Beginning of Worksheet
15. Ctrl + End – Go to Last Used Cell
16. Page Up/Page Down – Move One Screen Up/Down
17. Alt + Page Up/Page Down – Move One Screen Left/Right
3. Editing Cells and Data
18. F2 – Edit Active Cell
19. Esc – Cancel Entry
20. Enter – Complete Entry
21. Ctrl + D – Fill Down
22. Ctrl + R – Fill Right
23. Alt + Enter – Insert New Line in Cell
24. Ctrl + ; (Semicolon) – Insert Current Date
25. Ctrl + Shift + : (Colon) – Insert Current Time
4. Formatting and Styles
26. Ctrl + B – Bold
27. Ctrl + I – Italic
28. Ctrl + U – Underline
29. Ctrl + 1 – Format Cells Dialog Box
30. Ctrl + Shift + $ – Apply Currency Format
31. Ctrl + Shift + % – Apply Percentage Format
32. Ctrl + Shift + # – Apply Date Format
33. Ctrl + Shift + ^ – Apply Scientific Format
34. Ctrl + Shift + & – Apply Border
35. Ctrl + Shift + _ – Remove Border
5. Working with Rows, Columns, and Sheets
36. Ctrl + Space – Select Entire Column
37. Shift + Space – Select Entire Row
38. Ctrl + Shift + + – Insert Cell/Row/Column
39. Ctrl + - – Delete Cell/Row/Column
40. Alt + H + O + R – Rename Sheet
41. Ctrl + Page Up/Page Down – Switch Sheets
6. Formulas and Functions
42. = – Start Formula
43. Alt + = – AutoSum
44. Ctrl + ` – Toggle Formula View
45. F4 – Toggle Absolute/Relative References
46. Shift + F3 – Insert Function
7. Data Management
47. Ctrl + T – Create Table
48. Alt + A + T – Filter Data
49. Alt + A + S + S – Sort Data
8. Miscellaneous
50. F7 – Spell Check
