15/09/2026
# # MS Excel CTRL Key Shortcuts
# # # 🔹 Basic Editing & File Shortcuts
1. **Ctrl + N** — Create a new workbook.
2. **Ctrl + O** — Open an existing workbook.
3. **Ctrl + S** — Save the workbook.
4. **Ctrl + P** — Print the workbook.
5. **Ctrl + W** — Close the current workbook.
6. **Ctrl + F4** — Close the current workbook window.
7. **Ctrl + C** — Copy selected cells.
8. **Ctrl + X** — Cut selected cells.
9. **Ctrl + V** — Paste copied/cut data.
10. **Ctrl + Z** — Undo the last action.
11. **Ctrl + Y** — Redo/repeat the last action.
12. **Ctrl + F** — Find text or data.
13. **Ctrl + H** — Find and Replace.
14. **Ctrl + A** — Select the current data range/all data.
15. **Ctrl + K** — Insert a hyperlink.
# # # 🔹 Cell Formatting Shortcuts
16. **Ctrl + 1** — Open the Format Cells dialog box.
17. **Ctrl + B** — Apply/remove Bold.
18. **Ctrl + I** — Apply/remove Italic.
19. **Ctrl + U** — Apply/remove Underline.
20. **Ctrl + 5** — Apply/remove Strikethrough.
21. **Ctrl + Shift + ~** — Apply General number format.
22. **Ctrl + Shift + $** — Apply Currency format.
23. **Ctrl + Shift + %** — Apply Percentage format.
24. **Ctrl + Shift + ^** — Apply Scientific format.
25. **Ctrl + Shift + #** — Apply Date format.
26. **Ctrl + Shift + @** — Apply Time format.
27. **Ctrl + Shift + !** — Apply Number format.
# # # 🔹 Navigation Shortcuts
28. **Ctrl + Right Arrow** — Move to the right edge of the current data region.
29. **Ctrl + Left Arrow** — Move to the left edge of the current data region.
30. **Ctrl + Up Arrow** — Move to the top edge of the current data region.
31. **Ctrl + Down Arrow** — Move to the bottom edge of the current data region.
32. **Ctrl + Home** — Go to the beginning of the worksheet (usually A1).
33. **Ctrl + End** — Go to the last used cell of the worksheet.
34. **Ctrl + Page Up** — Move to the previous worksheet.
35. **Ctrl + Page Down** — Move to the next worksheet.
# # # 🔹 Selection Shortcuts
36. **Ctrl + Shift + Right Arrow** — Select to the right edge of the data region.
37. **Ctrl + Shift + Left Arrow** — Select to the left edge of the data region.
38. **Ctrl + Shift + Up Arrow** — Select to the top edge of the data region.
39. **Ctrl + Shift + Down Arrow** — Select to the bottom edge of the data region.
40. **Ctrl + Spacebar** — Select the entire column.
41. **Ctrl + Shift + Spacebar** — Select the current region/worksheet depending on context.
42. **Ctrl + A** — Select the current data region; pressing again can select the entire worksheet.
# # # 🔹 Data Entry & Formula Shortcuts
43. **Ctrl + Enter** — Fill all selected cells with the current entry.
44. **Ctrl + D** — Fill down.
45. **Ctrl + R** — Fill right.
46. **Ctrl + ;** — Enter the current date.
47. **Ctrl + Shift + ;** — Enter the current time.
48. **Ctrl + '** — Copy the formula from the cell above.
49. **Ctrl + Shift + "** — Copy the value from the cell above.
50. **Ctrl + `** — Show/hide formulas.
51. **Ctrl + Shift + Enter** — Enter an array formula in older Excel versions.
# # # 🔹 Insert/Delete & Calculation
52. **Ctrl + Shift + +** — Insert cells, rows, or columns.
53. **Ctrl + -** — Delete selected cells, rows, or columns.
54. **Ctrl + 9** — Hide selected rows.
55. **Ctrl + Shift + 9** — Unhide selected rows.
56. **Ctrl + 0** — Hide selected columns.
57. **Ctrl + Shift + 0** — Unhide selected columns *(may be restricted by Windows settings in some versions)*.
58. **Ctrl + Shift + =** — Insert cells/rows/columns (alternative to Ctrl + Shift + +).
59. **Ctrl + Alt + F9** — Recalculate all formulas in all open workbooks.
60. **Ctrl + Alt + Shift + F9** — Recheck dependent formulas and recalculate all formulas.
# # # 🔹 Special Excel Shortcuts
61. **Ctrl + T** — Create a Table.
62. **Ctrl + L** — Create a Table (in many Excel versions).
63. **Ctrl + Shift + L** — Turn AutoFilter on/off.
64. **Ctrl + E** — Flash Fill.
65. **Ctrl + Q** — Quick Analysis.
66. **Ctrl + G** — Open Go To dialog box.
67. **Ctrl + J** — Insert a line break in Find/Replace (in applicable contexts).
68. **Ctrl + M** — Not a standard Excel worksheet shortcut; behavior can depend on add-ins/macros.
69. **Ctrl + Shift + O** — Select cells containing comments/notes in supported Excel versions.
70. **Ctrl + 6** — Show/hide objects, depending on Excel settings.
# # # ⭐ Most Useful Ctrl Shortcuts to Remember
* **Ctrl + C** → Copy
* **Ctrl + X** → Cut
* **Ctrl + V** → Paste
* **Ctrl + Z** → Undo
* **Ctrl + Y** → Redo
* **Ctrl + S** → Save
* **Ctrl + F** → Find
* **Ctrl + H** → Replace
* **Ctrl + 1** → Format Cells
* **Ctrl + T** → Create Table
* **Ctrl + Shift + L** → Filter
* **Ctrl + E** → Flash Fill
* **Ctrl + D** → Fill Down
* **Ctrl + R** → Fill Right
* **Ctrl + Space** → Select Column
* **Ctrl + Home** → Go to A1
* **Ctrl + End** → Go to last used cell
* **Ctrl + Arrow Key** → Jump to edge of data region
* **Ctrl + Shift + Arrow Key** → Select data quickly