Top 83 Advanced Excel Shortcuts

 83 Advanced Excel Shortcuts that may be helpful:

1. Ctrl + Shift + :  -  Enter current time
2. Ctrl + ;  -  Enter current date
3. Ctrl + Shift + #  -  Apply date format (short date)
4. Ctrl + Shift + $  -  Apply currency format
5. Ctrl + Shift + %  -  Apply percentage format
6. Ctrl + Shift + ^  -  Apply scientific format
7. Ctrl + Shift + @  -  Apply time format
8. Ctrl + Shift + !  -  Apply number format
9. Ctrl + Shift + &  -  Apply outline border
10. Alt + =  -  Auto sum selected cells
11. Ctrl + Shift + :  -  Enter current time
12. Ctrl + ;  -  Enter current date
13. Ctrl + Shift + '  -  Copy value from cell above
14. Ctrl + Shift + ~  -  Apply general format
15. Ctrl + Shift + _  -  Remove outline border
16. Ctrl + Shift + +  -  Insert new row or column
17. Ctrl + Shift + -  -  Delete selected row or column
18. Ctrl + Shift + *  -  Select current region
19. Ctrl + Shift + ^  -  Apply scientific format
20. Ctrl + Space  -  Select entire column
21. Shift + Space  -  Select entire row
22. Ctrl + Shift + Space  -  Select entire sheet
23. Alt + Enter  -  Insert line break in cell
24. Ctrl + Z  -  Undo last action
25. Ctrl + Y  -  Redo last undone action
26. Ctrl + F  -  Find and Replace
27. Ctrl + H  -  Find and Replace
28. Ctrl + G  -  Go To
29. F5  -  Go To
30. Ctrl + A  -  Select all cells
31. Ctrl + B  -  Bold selected text
32. Ctrl + I  -  Italicize selected text
33. Ctrl + U  -  Underline selected text
34. Ctrl + 5  -  Strikethrough selected text
35. Ctrl + 1  -  Open Format Cells dialog box
36. Ctrl + Shift + F  -  Apply or remove filter
37. Ctrl + Shift + L  -  Apply or remove filter
38. Ctrl + Shift + O  -  Sort ascending
39. Ctrl + Shift + P  -  Sort descending
40. F11  -  Create chart
41. Shift + F11  -  Create new sheet
42. Ctrl + Page Up  -  Switch to previous sheet
43. Ctrl + Page Down  -  Switch to next sheet
44. Ctrl + Tab  -  Switch between open workbooks
45. Ctrl + W  -  Close workbook
46. Ctrl + S  -  Save workbook
47. Ctrl + F12  -  Save As
48. F12  -  Save As
49. Ctrl + P  -  Print
50. Ctrl + Shift + ;  -  Enter current date
51. Ctrl + Shift + '  -  Enter current time
52. Ctrl + Shift + "  -  Copy formula from above
53. Ctrl + Shift + =  -  Insert formula
54. Ctrl + Shift + -  -  Delete cell contents
55. Ctrl + Shift + +  -  Insert cell
56. Ctrl + Shift + *  -  Select current region
57. Ctrl + Shift + ^  -  Apply scientific format
58. Ctrl + Shift + %  -  Apply percentage format
59. Ctrl + Shift + #  -  Apply date format
60. Ctrl + Shift + @  -  Apply time format
61. Ctrl + Shift + !  -  Apply number format
62. Ctrl + Shift + &  -  Apply outline border
63. Ctrl + Shift + _  -  Remove outline border
64. Ctrl + Shift + :  -  Apply time format
65. Ctrl + Shift + ;  -  Apply date format
66. Ctrl + Shift + ~  -  Apply general format
67. Ctrl + Shift + $  -  Apply currency format
68. Ctrl + Shift + <  -  Apply number format
69. Ctrl + Shift + >  -  Apply number format
70. Ctrl + Shift + {  -  Group
71. Ctrl + Shift + }  -  Ungroup
72. Ctrl + Shift + (  -  Show outline symbol
73. Ctrl + Shift + )  -  Hide outline symbol
74. Ctrl + Shift + \  -  Clear outline
75. Ctrl + Shift + /  -  Select visible cells
76. Ctrl + Shift + "  -  Copy formula from above
77. Ctrl + Shift + =  -  Insert formula
78. Ctrl + Shift + -  -  Delete cell contents
79. Ctrl + Shift + +  -  Insert cell
80. Ctrl + Shift + *  -  Select current region
81. Ctrl + Shift + ^  -  Apply scientific format
82. Ctrl + Shift + %  -  Apply percentage format
83. Ctrl + Shift + #  -  Apply date format