Top 20 Advance Excel Shortcuts

Here are some advanced Excel shortcuts that can help you work more efficiently:

1. Ctrl + Shift + : Enter the current time.
2. Ctrl + ; Enter the current date.
3. Ctrl + Shift + &: Apply the outline border to the selected cells.
4. Ctrl + Shift + _: Remove the outline border from the selected cells.
5. Ctrl + Shift + @: Apply the time format to the selected cells.
6. Ctrl + Shift + $: Apply the currency format to the selected cells.
7. Ctrl + Shift + %: Apply the percentage format to the selected cells.
8. Ctrl + Shift + ^: Apply the scientific format to the selected cells.
9. Ctrl + Alt + V: Display the Paste Special dialog box.
10. Ctrl + Shift + #: Apply the date format to the selected cells.
11. Ctrl + Shift + !: Apply the number format to the selected cells.
12. Ctrl + Shift + ~: Apply the general format to the selected cells.
13. Ctrl + Alt + F: Display the Format Cells dialog box.
14. Ctrl + 1: Display the Format Cells dialog box.
15. Ctrl + Shift + *: Select the current region around the active cell (the data range surrounded by blank rows and columns).
16. Ctrl + F3: Define a new name for a range of cells.
17. Ctrl + Shift + F3: Insert a function into a cell.
18. Ctrl + Alt + F3: Create a new name from the selected cells.
19. Ctrl + Shift + Enter: Enter an array formula into multiple cells at once.
20. Ctrl + Alt + =: AutoSum a range of cells.

These advanced Excel shortcuts can help you work more efficiently and save time by allowing you to perform tasks quickly and easily.