Scroll Trouble in Excel is something we all encounter at one time or another. And as small as the "trouble" appears, it does limit your abilities in Excel as several Excel staples (Ctrl+End, Ctrl+Down Arrow...) don't perform as one would expect. This video showcases how to solve Scroll Trouble in Excel.
This tutorial was made using Excel 365, but the techniques showed in the video can be applied in any Excel since the 1997 version.
Chapters:
0:00 Excel Olympics Animation
0:08 What is Scroll Trouble In Excel
2:08 Solution 1 - 10 Year Old's Approach
3:59 Solution 2 - The Proper Solution
6:33 Outro
6:40 Bloopers
You can read the accompanying blog post here: https://bit.ly/3xuHNPc
The post includes a VBA solution as I couldn't find a viable way to present VBA code over Youtube.
Gear Used:
US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission with NO additional charge to you! Thank you for your support!
#Excel #ExcelOlympics #gasperkamensek