❤️ Top 50 Shortcuts in 30 Minutes

❤️ Click here for more videos ⬇️

Video 1: Top 30 Excel Tips and Tricks to save 30+ hours of work
   • ❤️ Top 30 Excel Tips and Tricks to sa...  

Video 2: Link every worksheet to a Master Sheet in Excel (10 Levels)
   • Link every worksheet to a Master Shee...  

Video 3: Jump to Any Sheet with Excel Shortcut (5 Levels)
   • Jump to Any Sheet with Excel Shortcut...  

Video 4: List All Your Sheets Efficiently in Excel (10 Levels)
   • List All Your Sheets Efficiently in E...  

Video 5: Highlight Active Row & Column in Excel (7 Levels)
   • Highlight Active Row & Column in Exce...  

❤️ Chapters:

*Level 1: Multi Purpose Shortcuts + Easy Navigation*

00:35 1. Search Box (ALT + Q)
02:09 2. Repeat last action (F4)
03:47 3. Next worksheet (CTRL + PgDn)
04:04 4. Previous worksheet (CTRL + PgUp)
04:15 5. Add date stamp (CTRL + ;)
04:33 6. Navigate Fast (CTRL + arrows)
05:01 7. Select Fast (CTRL + SHIFT + arrows)
06:02 8. Fill Right (CTRL + R)
06:31 9. Fill Down (CTRL + D)
06:51 10. Combo Unlocked (copy down 1)

*Level 2: Rows & Columns 1 + Paste Values*

07:41 11. Paste Values (CTRL + ALT + V → V)
08:34 12. Row Height (ALT → H, O, H)
08:53 13. Autofit Column Width (ALT → H, O, I)
09:21 14. Select Entire Column (CTRL + Space)
09:45 15. Combo Unlocked (Fit column width)
10:16 16. Select Entire Row (SHIFT + Space)
10:34 17. Delete (CTRL + - brings up dialog box)
11:00 18. Combo Unlocked (Delete row or column)
11:30 19. Insert (CTRL + SHIFT + ‘+’ to bring up dialog box)
11:58 20. Combo Unlocked (Insert row or column)

*Level 3: Rows & Columns 2 + Format Cell*

12:21 21. Hide row (CTRL + 9)
12:33 22. Unhide row (CTRL + SHIFT + 9)
12:56 23. Hide column (CTRL + 0)
13:11 24. Unhide column (CTRL + SHIFT + 0)
13:33 25. Check for hidden rows or columns (ALT + ;)
14:08 26. Group row or column (SHIFT + ALT + Right arrow)
15:01 27. Ungroup row or column (SHIFT + ALT + Left arrow)
15:28 28. Remove all row and column groups from sheet (ALT → A, U, C)
15:49 29. Insert (or edit) comment in cell (SHIFT + F2)
16:23 30. Format Cell Dialog Box (CTRL + 1)

*Level 4: Hyperlinks, Name, Find, Flash fill, Filters*

16:58 31. Insert hyperlink (CTRL + K)
17:52 32. Name Box (ALT + F3)
19:01 33. Find next cell (SHIFT + F4)
19:33 34. Flash Fill email addresses (CTRL + E)
20:10 35. Apply Filters (CTRL + SHIFT + L)
20:33 36. Activate Filter (ALT + Down arrow)
21:02 37. Combo Unlocked (Apply filters)
21:30 38. Filter Search Box (ALT + Down Arrow → E)
22:04 39. Clear Filters in Column (ALT + Down Arrow → C)
22:31 40. Clear All Filters (ALT → A, C)

*Level 5: Autocorrect, Emojis, Formula Auditing, Quick Access Toolbar, Slicers*

23:01 41. Autocorrect to replace text string xfile → =TEXTAFTER(TEXTBEFORE(CELL("filename"),"]"),"[")
24:48 42. Windows Emoji Picker for symbols (WIN + .)
25:23 43. Combo Unlocked (Emoji picker with autocorrect)
26:44 44. Highlight cells with constants (CTRL + G or F5 → ALT + S → O, X → Enter)
27:28 45. Highlight cells with formulas (CTRL + G or F5 → ALT + S → F → Enter)
27:53 46. Trace Dependents (ALT → M, D)
28:22 47. Trace Precedents (ALT → M, P)
28:59 48. Clear Formula Auditing Arrows (ALT → M, A, A)
29:31 49. Customize QAT (ALT + number key)
32:16 50. Slicers to filter Tables faster (Power Tip)

🚀 BEST EXCEL RESOURCES

Launch Excel Macros & VBA School:

Say Goodbye to Tedious Manual Work and Automate Your Way with Excel VBA. Our course helps you to learn Excel VBA and save hours of time every week even if you have zero prior experience with programming.

➡️ https://www.launchexcel.com/shop

Excel Dashboards: Learn how to make killer dashboards in Excel. They will set your skills apart from the crowd. Invest in your data reporting and presentation skills.

➡️ https://go.launchexcel.com/moth-dashb...

Explore 100+ Excel Templates: Save time and streamline your workflow. Here is a selection of over 100 spreadsheet templates. They cover Accounting, Finance, Data Analysis, HR, Operations, Project Management, Real Estate, Sales & Marketing, Small Business, and Management.

➡️ https://www.launchexcel.com/best-exce...

🚀 Ready to launch your Excel skills into orbit?
Subscribe to the Launch Excel channel for more stellar Excel tips and tricks! And check out our website www.launchexcel.com for in-depth tutorials.