My ctr+shift+dwn arrow works in stable mode only but not in regular mode. I am pulling my hair out. I am in Parallels and use the AulaF75 keyboard, but I am unsure if those two factors matter.
Oh no, that sounds really annoying. I use Parallels too (running Windows Excel on a Mac). But I don't use the AulaF75 keyboard, have you set that up for specific shortcuts? When you say it runs in "stable mode" is that safe mode that you access by holding down CTRL when you launch Excel? One last thought, maybe you're running an Excel add-in or other app that interferes with the keyboard shortcut? As it, it intercepts CTRL + SHIFT + Down Arrow for some other purpose.
❤ *More videos + Chapter Timings* ⬇
Video 1: Top 30 Excel Tips and Tricks to save 30+ hours of work
ua-cam.com/video/hoUnZVRulLc/v-deo.html
Video 2: Link every worksheet to a Master Sheet in Excel (10 Levels)
ua-cam.com/video/G7SOJvtUUrc/v-deo.html
Video 3: Jump to Any Sheet with Excel Shortcut (5 Levels)
ua-cam.com/video/gcR74zWd5a0/v-deo.html
Video 4: List All Your Sheets Efficiently in Excel (10 Levels)
ua-cam.com/video/SyGLWog59GA/v-deo.html
Video 5: Highlight Active Row & Column in Excel (7 Levels)
ua-cam.com/video/2bWObFD_CEI/v-deo.html
*❤ 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)*
🥰🥰🥰 Love this video. Thank you for sharing.
Thank you so much for your kind words, @mylenevelez770! 😊
Thanks bro, from Indonesian 👏🏻
No problem 👍 glad you like it!
Thank you :) Now my Excel workbook will be cute with colourful emojis :)
You're welcome 😊
@0:25 Correction: Shortcut to insert a new worksheet is Alt+Shift+F1 (ie: no ctrl key) or alternatively Shift+F11
Thank you for pointing that out, you're 100% correct!
My ctr+shift+dwn arrow works in stable mode only but not in regular mode. I am pulling my hair out. I am in Parallels and use the AulaF75 keyboard, but I am unsure if those two factors matter.
Oh no, that sounds really annoying. I use Parallels too (running Windows Excel on a Mac). But I don't use the AulaF75 keyboard, have you set that up for specific shortcuts?
When you say it runs in "stable mode" is that safe mode that you access by holding down CTRL when you launch Excel?
One last thought, maybe you're running an Excel add-in or other app that interferes with the keyboard shortcut? As it, it intercepts CTRL + SHIFT + Down Arrow for some other purpose.
In Excel in PT-BR language, the shortcut key is Alt G and not Alt Q. 🤗
Thanks for sharing the PT-BR shortcut 😄