Advanced Excel all useful shortcuts.

1. Ctrl + A: Selects all cells in the worksheet.
2. Ctrl + C: Copies the selected cells.
3. Ctrl + V: Pastes the copied cells.
4. Ctrl + X: Cuts the selected cells.
5. Ctrl + Z: Undoes the last action.
6. Ctrl + Y: Redoes the last action.
7. Ctrl + F: Opens the "Find and Replace" dialog box.
8. Ctrl + H: Opens the "Find and Replace" dialog box with the "Replace" tab selected.
9. Ctrl + N: Creates a new workbook.
10. Ctrl + O: Opens an existing workbook.
11. Ctrl + S: Saves the current workbook.
12. Ctrl + P: Opens the print dialog box.
13. Ctrl + E: Activates the search box at the top of the Excel window.
14. Ctrl + Shift + L: Applies filters to the selected cells.
15. Ctrl + ; (semi-colon): Inserts the current date.
16. Ctrl + ; (semi-colon): Inserts the current date.
17. Ctrl + Shift + ; (semi-colon): Inserts the current time.
18. Alt + F11: Opens the Visual Basic Editor.
19. Alt + Enter: Starts a new line within a cell.
20. Alt + = (equals sign): Inserts the SUM function to add up a range of cells.
21. F2: Edits the active cell.
22. F4: Repeats the last action.
23. F5: Opens the "Go To" dialog box.
24. F7: Opens the "Spelling" dialog box.
25. F11: Creates a chart of the selected data.
26. Shift + F11: Inserts a new worksheet.
27. Shift + Arrow Keys: Selects multiple cells in a row or column.
28. Ctrl + Shift + Arrow Keys: Selects all cells from the active cell to the last non-blank cell in the same direction as the arrow key.
29. Ctrl + Page Up/Page Down: Switches between worksheet tabs.
30. Ctrl + Shift + $: Applies the currency format to the selected cells.
31. Ctrl + Shift + #: Applies the date format to the selected cells.
32. Ctrl + Shift + %: Applies the percentage format to the selected cells.

33. Ctrl + Shift + ~: Applies the General format to the selected cells.
34. Ctrl + Shift + &: Applies a border to the selected cells.
35. Ctrl + Shift + _: Removes the border from the selected cells.
36. Ctrl + Shift + ^: Applies the exponentiation format to the selected cells.
37. Ctrl + Shift + @: Applies the time format to the selected cells.
38. Ctrl + Shift + #: Applies the number format with a date format to the selected cells.
39. Ctrl + Shift + *: Selects the current region around the active cell.
40. Alt + F: Opens the "File" tab on the ribbon.
41. Alt + E + S + V: Opens the "Paste Special" dialog box.
42. Alt + W + F + F: Freezes the panes in the worksheet.
43. Alt + H + O + I: Hides the selected rows.
44. Alt + H + O + U: Unhides the selected rows.
45. Alt + H + O + C: Clears the contents of the selected cells.
46. Alt + H + I + R: Inserts a row above the active cell.
47. Alt + H + D + D: Deletes the selected rows.