❤️ Top 50 Shortcuts in 30 Minutes 

❤ *More videos + Chapter Timings* ⬇ Video 1: Top 30 Excel Tips and Tricks to save 30+ hours of work ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hoUnZVRulLc.html Video 2: Link every worksheet to a Master Sheet in Excel (10 Levels) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-G7SOJvtUUrc.html Video 3: Jump to Any Sheet with Excel Shortcut (5 Levels) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gcR74zWd5a0.html Video 4: List All Your Sheets Efficiently in Excel (10 Levels) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-SyGLWog59GA.html Video 5: Highlight Active Row & Column in Excel (7 Levels) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2bWObFD_CEI.html *❤ Chapters:* **Level 1: Multi Purpose Shortcuts + Easy Navigation** <a href="#" class="seekto" data-time="35">00:35</a> 1. *Search Box* (ALT + Q) <a href="#" class="seekto" data-time="129">02:09</a> 2. *Repeat last action* (F4) <a href="#" class="seekto" data-time="227">03:47</a> 3. *Next worksheet* (CTRL + PgDn) <a href="#" class="seekto" data-time="244">04:04</a> 4. *Previous worksheet* (CTRL + PgUp) <a href="#" class="seekto" data-time="255">04:15</a> 5. *Add date stamp* (CTRL + ;) <a href="#" class="seekto" data-time="273">04:33</a> 6. *Navigate Fast* (CTRL + arrows) <a href="#" class="seekto" data-time="301">05:01</a> 7. *Select Fast* (CTRL + SHIFT + arrows) <a href="#" class="seekto" data-time="362">06:02</a> 8. *Fill Right* (CTRL + R) <a href="#" class="seekto" data-time="391">06:31</a> 9. *Fill Down* (CTRL + D) <a href="#" class="seekto" data-time="411">06:51</a> 10. *Combo Unlocked* (copy down 1) **Level 2: Rows & Columns 1 + Paste Values** <a href="#" class="seekto" data-time="461">07:41</a> 11. *Paste Values* (CTRL + ALT + V → V) <a href="#" class="seekto" data-time="514">08:34</a> 12. *Row Height* (ALT → H, O, H) <a href="#" class="seekto" data-time="533">08:53</a> 13. *Autofit Column Width* (ALT → H, O, I) <a href="#" class="seekto" data-time="561">09:21</a> 14. *Select Entire Column* (CTRL + Space) <a href="#" class="seekto" data-time="585">09:45</a> 15. *Combo Unlocked* (Fit column width) <a href="#" class="seekto" data-time="616">10:16</a> 16. *Select Entire Row* (SHIFT + Space) <a href="#" class="seekto" data-time="634">10:34</a> 17. *Delete* (CTRL + - brings up dialog box) <a href="#" class="seekto" data-time="660">11:00</a> 18. *Combo Unlocked* (Delete row or column) <a href="#" class="seekto" data-time="690">11:30</a> 19. *Insert* (CTRL + SHIFT + ‘+’ to bring up dialog box) <a href="#" class="seekto" data-time="718">11:58</a> 20. *Combo Unlocked* (Insert row or column) **Level 3: Rows & Columns 2 + Format Cell** <a href="#" class="seekto" data-time="741">12:21</a> 21. *Hide row* (CTRL + 9) <a href="#" class="seekto" data-time="753">12:33</a> 22. *Unhide row* (CTRL + SHIFT + 9) <a href="#" class="seekto" data-time="776">12:56</a> 23. *Hide column* (CTRL + 0) <a href="#" class="seekto" data-time="791">13:11</a> 24. *Unhide column* (CTRL + SHIFT + 0) <a href="#" class="seekto" data-time="813">13:33</a> 25. *Check for hidden rows or columns* (ALT + ;) <a href="#" class="seekto" data-time="848">14:08</a> 26. *Group row or column* (SHIFT + ALT + Right arrow) <a href="#" class="seekto" data-time="901">15:01</a> 27. *Ungroup row or column* (SHIFT + ALT + Left arrow) <a href="#" class="seekto" data-time="928">15:28</a> 28. *Remove all row and column groups from sheet* (ALT → A, U, C) <a href="#" class="seekto" data-time="949">15:49</a> 29. *Insert (or edit) comment in cell* (SHIFT + F2) <a href="#" class="seekto" data-time="983">16:23</a> 30. *Format Cell Dialog Box* (CTRL + 1) **Level 4: Hyperlinks, Name, Find, Flash fill, Filters** <a href="#" class="seekto" data-time="1018">16:58</a> 31. *Insert hyperlink* (CTRL + K) <a href="#" class="seekto" data-time="1072">17:52</a> 32. *Name Box* (ALT + F3) <a href="#" class="seekto" data-time="1141">19:01</a> 33. *Find next cell* (SHIFT + F4) <a href="#" class="seekto" data-time="1173">19:33</a> 34. *Flash Fill email addresses* (CTRL + E) <a href="#" class="seekto" data-time="1210">20:10</a> 35. *Apply Filters* (CTRL + SHIFT + L) <a href="#" class="seekto" data-time="1233">20:33</a> 36. *Activate Filter* (ALT + Down arrow) <a href="#" class="seekto" data-time="1262">21:02</a> 37. *Combo Unlocked* (Apply filters) <a href="#" class="seekto" data-time="1290">21:30</a> 38. *Filter Search Box* (ALT + Down Arrow → E) <a href="#" class="seekto" data-time="1324">22:04</a> 39. *Clear Filters in Column* (ALT + Down Arrow → C) <a href="#" class="seekto" data-time="1351">22:31</a> 40. *Clear All Filters* (ALT → A, C) **Level 5: Autocorrect, Emojis, Formula Auditing, Quick Access Toolbar, Slicers** <a href="#" class="seekto" data-time="1381">23:01</a> 41. *Autocorrect to replace text string* xfile → =TEXTAFTER(TEXTBEFORE(CELL("filename"),"]"),"[") <a href="#" class="seekto" data-time="1488">24:48</a> 42. *Windows Emoji Picker for symbols* (WIN + .) <a href="#" class="seekto" data-time="1523">25:23</a> 43. *Combo Unlocked* (Emoji picker with autocorrect) <a href="#" class="seekto" data-time="1604">26:44</a> 44. *Highlight cells with constants* (CTRL + G or F5 → ALT + S → O, X → Enter) <a href="#" class="seekto" data-time="1648">27:28</a> 45. *Highlight cells with formulas* (CTRL + G or F5 → ALT + S → F → Enter) <a href="#" class="seekto" data-time="1673">27:53</a> 46. *Trace Dependents* (ALT → M, D) <a href="#" class="seekto" data-time="1702">28:22</a> 47. *Trace Precedents* (ALT → M, P) <a href="#" class="seekto" data-time="1739">28:59</a> 48. *Clear Formula Auditing Arrows* (ALT → M, A, A) <a href="#" class="seekto" data-time="1771">29:31</a> 49. *Customize QAT* (ALT + number key) <a href="#" class="seekto" data-time="1936">32:16</a> 50. *Slicers to filter Tables faster (Power Tip)*

Thanks bro, from Indonesian 👏🏻

Thank you :) Now my Excel workbook will be cute with colourful emojis :)

🥰🥰🥰 Love this video. Thank you for sharing.

In Excel in PT-BR language, the shortcut key is Alt G and not Alt Q. 🤗