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-editor.html

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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.