Advance Excel Shortcut Keys You Must Know in 2024

Excel is the most essential software in today’s world. Advance Excel Shortcut Keys You Must Know in 2024. Its use spans across organizations, schools, colleges, corporate offices, and even IT firms. With Excel, you can easily validate large datasets and organize them based on your requirements.

So today we will use the most basic as well as the most advanced shortcut keys used in Excel in this article, so let’s get started. Advanced Excel Shortcut Keys You Must Know in 2024.

How to Use Shortcut Keys in Excel

As we know, Excel is the most advanced tool at this time, and most people use it to create financial reports, financial presentations, company bios, company theses, operational management, human resource management systems, etc.

In Excel, we can use multiple types of formulas such as Sum, Count, Length, Concatenate, and many more, which we will study today. This tool has been provided to us by Microsoft. Additionally, in Excel, we can use shortcut keys to execute even the largest tasks very quickly.

How to Freeze Rows and Columns in Excel Shortcut Keys

In Excel, data is stored in the form of rows and columns. If you want to freeze these rows or columns, you can use this command.
Alt+W+F+F: You can freeze rows or columns before selecting them in this.
Alt+W+F+R: You can freeze the first row with this command.
Alt+W+F+C: With the help of this command, you can freeze the first column of your worksheet.
You can also freeze the selected rows or columns in Excel using the View panel provided in the toolbar.

How to Change Small Letters to Capital Letters in Excel Shortcut Keys

If you want to change letters from small to capital and from capital to small, you can press Shift + F3 to change to your desired format.
You can also change text cases using built-in functions, such as
UPPER: You change the text to uppercase.
LOWER: You change this text context to lowercase
PROPER: You change this into proper text.

General Excel Shortcut Keys and Advance Excel Shortcut Keys You Must Know in 2024

Let’s Start the Shortcuts Advance Excel Shortcut Keys You Must Know in 2024

General Excel Shortcuts

1. Ctrl + N – For Create New workbook
2. Ctrl + O – For Open workbook
3. Ctrl + S – For Save workbook
4. F12 – For Save As
5. Ctrl + P – For Printing the Page
6. Ctrl + W – For Close workbook
7. Ctrl + F4 – For Close Excel
8. Ctrl + Z – For Undo the Text
9. Ctrl + Y -For Redo the Text
10. Ctrl +X – For Cut the Text
11. Ctrl + C – For Copy the Text from Cell
12. Ctrl + V – For Paste the Text
13. Ctrl + A – Select all Text
14. Ctrl + F – Find The Text
15. Ctrl + H – Replace The Text
16. Ctrl + K – Insert hyperlink in the Excel
17. Ctrl + R – Fill right Text
18. Ctrl + D – Fill down Text
19. Ctrl + E – Flash fill the Text
20. Ctrl + U – Underline the Text
21. Ctrl + B – Bold the Text
22. Ctrl + I – Italic Text
23. Ctrl + 1 – Format cells dialog box
24. Ctrl + 9 – Hide rows From File
25. Ctrl + Shift + 9 – Unhide rows From Excel
26. Ctrl + 0 – Hide columns From Excel
27. Ctrl + Shift + 0 – Unhide columns From Excel
28. Ctrl + Shift + L – Toggle filters From Excel
29. Ctrl + T – Create a table in the Excel File
30. Ctrl + Shift + “+” – Insert row or column in the Excel Worksheet
31. Ctrl + “-“ – Delete row or column from Excel File
32. Ctrl + Arrow keys – Move to the edge of the data region
33. Ctrl + Space – Select the entire column in the sheet
34. Shift + Space – Select the entire row in the sheet
35. Alt + E, S, V – Paste special in the Excel sheet
36. Alt + H, A, C – AutoFit column width in the Excel
37. Alt + H, A, R – AutoFit row height from Excel
38. Alt + E, S, T – Paste transpose in Excel
39. Alt + H, M, C – Merge and center in Excel
40. Alt + H, M, A – Unmerge cells in Excel
41. Alt + H, O, I – AutoFit column width in Excel
42. Alt + H, O, A – AutoFit row height in Excel
43. Alt + N, V – Insert PivotTable in the Excel
44. Alt + N, T – Insert table in the Excel
45. Alt + N, H – Insert histogram chart in Excel
46. Alt + A, S – Sort data in the Excel File
47. Alt + A, F – Filter data in the Excel
48. Alt + H, O, M – Merge cells in Exel
49. Alt + H, H – Fill color in the Excel
50. Alt + H, F, C – Font color in the Excel

Navigation Shortcuts

51. Ctrl + Home – Go to the beginning of the Excel sheet
52. Ctrl + End – Go to the end of the Excel sheet
53. Ctrl + Page Up – Switch to the previous Excel sheet
54. Ctrl + Page Down – Switch to the next Excel sheet
55. Alt + Page Up – Move one screen to the left Excel Sheet
56. Alt + Page Down – Move one screen to the right Excel Sheet
57. Ctrl + Arrow keys – Move to the edge of the data region Excel sheet
58. Home – Move to the beginning of the row Excel Sheet
59. End – Move to the end of the row Excel Sheet
60. Ctrl + G – Go to a specific cell Excel Sheet

Formula Shortcuts

61. = – Start a formula We use =
62. Ctrl + Shift + Enter – Enter an array formula in Excel Sheet
63. F2 – Edit active cell in Excel Sheet
64. Ctrl + Shift + F3 – Create names from selection in Excel Sheet
65. Ctrl + Shift + U – Expand or collapse formula bar in Excel Sheet
66. F4 – Repeat last action in Excel Sheet
67. Ctrl + ` – Toggle the display of formulas in Excel Sheet

Data Management Shortcuts

68. Ctrl + Shift + K – Create a named range in Excel Sheet
69. Alt + D, F, F – Filter data in Excel Sheet
70. Alt + A, S, S – Sort ascending in Excel Sheet
71. Alt + A, S, D – Sort descending in Excel Sheet
72. Alt + H, F, I – Find and select in Excel Sheet
73. Ctrl + Shift + L – Add or remove filters in Excel Sheet

Miscellaneous Shortcuts

74. Ctrl + Shift + C – Copy Formatting in Excel Sheet
75. Ctrl + Shift + V – Paste Formatting in Excel Sheet
76. Ctrl + T – Format as a table in Excel Sheet
77. Alt + E, S, V – Paste special in Excel Sheet
78. Alt + H, B, A – Add or remove borders in Excel Sheet
79. Alt + H, E, A – Clear all formatting in Excel Sheet
80. Ctrl + 5 – Strike by text in Excel Sheet
81. Ctrl + Shift + $ – Apply currency format in Excel Sheet
82. Ctrl + Shift + % – Apply percentage format in Excel Sheet
83. Ctrl + Shift + ! – Apply number format in Excel Sheet
84. Ctrl + Shift + ^ – Apply scientific format in Excel Sheet

Selection Shortcuts

85. Ctrl + Shift + Right Arrow – Select the end of the row in the Excel Sheet
86. Ctrl + Shift + Left Arrow – Select the beginning of the row in the Excel Sheet
87. Ctrl + Shift + Down Arrow – Select the end of the column in the Excel Sheet
88. Ctrl + Shift + Up Arrow – Select the beginning of the column in the Excel Sheet
89. Ctrl + A – Select all cells in the worksheet
90. Shift + Arrow keys – Extend selection by one cell in Excel Sheet

Cell Editing Shortcuts

91. F7 – Spell check in Excel Sheet
92. Ctrl + Shift + U – Expand or collapse the formula bar in the Excel Sheet
93. Ctrl + D – Fill down in Excel Sheet
94. Ctrl + R – Fill right in Excel Sheet
95. Ctrl +; – Enter current date in Excel Sheet
96. Ctrl + Shift +: – Enter the current time in Excel Sheet
97. Ctrl + Alt + V – Paste special dialog in Excel Sheet
98. Alt + Enter – Start a new line in the same cell in Excel Sheet

Pivot Table Shortcuts

99. Alt + N, V – Insert a PivotTable in Excel Sheet
100. Alt + J, T, T – Show PivotTable Tools in Excel Sheet

For Learn MS Word Please Visit Link

Frequently Asked Questions