Microsoft Excel Advanced Shortcuts you should know!

Microsoft Excel is developed by Microsoft for Windows, macOS, Android, and iOS under the name Microsoft Office. And IT professional should know excel advanced shortcuts as it features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

We know that most of our readers are in the IT sector and it is possible that they would be working upon this awesome spreadsheet tool developed by Microsoft.

Notable features of MS Excel

1. Pivot Tables
2. Filtering and sorting data
3. Excel Tables
4. Conditional formatting
5. Lookup Excel functions
6. Array Formulas
7. Data Analysis Excel Tools

Today in this post We are going to share 100+ advanced shortcuts in order to make your spreadsheet life easier!

MS Excel advanced shortcuts List:-

1. Open help: F1
2. Undo last action: Ctrl + Z
3. Redo last action: Ctrl + Y
4. Copy selection: Ctrl + C
5. Repeat last action: F4
6. Cut selection: Ctrl + X
7. Paste content from clipboard: Ctrl + V
8. Display the Paste Special dialog box: Ctrl + Alt + V
9. Display find and replace with Find tab selected: Ctrl + F
10. Display find and replace with Replace tab selected: Ctrl + H
11. Find previous match (after initial Find): Ctrl + Shift + F4
12. Find next match (after initial Find): Shift + F4
13. Insert embedded chart: Alt + F1
14. Insert chart in new sheet: F11
15. Toggle Autofilter: Ctrl + Shift + L
16. Activate filter: Alt + ↓
17. Create table: Ctrl + T OR Ctrl + L
18. Select table row: Shift + Space
19. Select table column: Ctrl + Space
20. Select table (when active cell is in table): Ctrl + A
21. Clear slicer filter: Alt + C
22. Run Spellcheck: F7
23. Open Thesaurus: Shift + F7
24. Open Macro dialog box: Alt + F8
25. Open VBA Editor: Alt + F11
26. Duplicate object, formula, text: Ctrl + D
27. Drag and copy: Ctrl + Drag
28. Drag and insert: Shift + Drag
29. Drag and insert copy: Ctrl + Shift + Drag
30. Drag to worksheet: Alt + Drag
31. Drag to duplicate worksheet: Ctrl + Drag
32. Create a pivot table: Alt + N, V
33. Select entire pivot table: Ctrl + A
34. Group pivot table items: Alt + Shift + →
35. Ungroup pivot table items: Alt + Shift + ←
36. Unhide (clear filter on) pivot table item: Alt + H, S
37. Insert pivot chart: Alt + N, S Z C
38. Begin entering a formula: = OR +
39. Open the Insert Function Dialog Box: Shift + F3
40. Enter array formula: Ctrl + Shift + Enter
41. Calculate worksheets: F9
42. Calculate active worksheet: Shift + F9
43. Force calculate all worksheets: Ctrl + Alt + F9
44. Expand or collapse the formula bar: Ctrl + Shift + U
45. Open Name Manager: Ctrl + F3
46. Create name from values in row(s)/column(s): Ctrl + Shift + F3
47. Apply general format: Ctrl + Shift + ~
48. Apply number format: Ctrl + Shift + !
49. Apply time format: Ctrl + Shift + @
50. Apply date format: Ctrl + Shift + #
51. Apply currency format: Ctrl + Shift + $
52. Apply percentage format: Ctrl + Shift + %
53. Apply scientific format: Ctrl + Shift + ^

FOR MACBOOK

1. Display the Style dialog box: ⌘ (Command) + Shift + l
2. Paste text: ⌘ + v
3. Display the Format Cells dialog box: ⌘ + 1
4. Apply the general number format: Ctrl + Shift + ~
5. Apply the currency format with two decimal places: Ctrl + Shift + $
6. Apply the percentage format with no decimal places: Ctrl + Shift + %
7. Apply the exponential number format with two decimal places: Ctrl + Shift + ^
8. Apply the date format with the day, month, and year: Ctrl + Shift + #
9. Apply the time format with the hour and minute: Ctrl + Shift + @
10. Apply the outline border around the selected cells: ⌘ + Option + 0 (zero)
11. Add an outline border to the right of the selection: ⌘ + Option + Arrow Right
12. Add an outline border to the left of the selection: ⌘ + Option + Arrow Left
13. Add an outline border to the top of the selection: ⌘ + Option + Arrow Up
14. Add an outline border to the bottom of the selection: ⌘ + Option + Arrow Down
15. Remove outline borders: ⌘ + Option + –
16. Apply / remove bold: ⌘ + b
17. Apply / remove italic: ⌘ + I
18. Apply / remove underscoring: ⌘ + u
19. Apply / remove strikethrough: ⌘ + Shift + x
20. Hide rows: Ctrl + 9
21. Hide columns: Ctrl + 0 (zero)
22. Unhide columns: Ctrl + Shift + )
23. Add or remove the shadow font style: ⌘ + Shift + w
24. Add or remove the outline font style: ⌘ + Shift + d
25. Edit the active cell: Ctrl + u
26. Enter a formula as an array formula: Ctrl + Shift + Return
    

All image credits to fb.com/TimeforLearning

Final Words

Microsoft Excel might be an old tool used by many tech people from early times but it is still one of the majorly used spreadsheet software till now and is used in data manipulation and for other tasks.

So that’s it! We have listed all the Excel advanced shortcuts you need to master Microsoft Excel. Note that these are the list of the shortcuts which would work in Windows only. It’s not meant for the Macbooks (Apple Computers)