In this video tutorial, learn how to create a scroll bar in Excel.
If you have a large dataset, you can use this technique to create a scroll bar and a scrollable list to show limited records. This gives the user a flexibility to scroll and go through the entire data.
The Excel Scrollbar option is available in the developer tab in Form Controls.
To create a scroll bar, you need to use a mix of excel formulas and to create a list that updates when you move the scroll bar.
This video has a step-by-step tutorial on how to create a scrollable list in Excel
Read more and Download File:
You May also like the following video:
—
—
—
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Thanks Sir.
OMG, this has been sooo helpful!! Thank you so much for this!!!
made my work easier 😁👍
This scrollbar option does not work in Excel Android app
Excellent video from your side. Keep it up
Hey,
nice video but this method is much faster and short way :👇👇
=INDEX(C4:C$31,$L$3)
put the formula on cell "H4" and drag it both way.
Excellent, thank you.
TRUMP 2020… am i rite?
Good job..
Thanks this works great. Better than using marco . How do you have it scroll automatically?
Hi Sumit.. this was very instructive.. offering two solutions with OFFSET and INDEX. I combined INDEX with MATCH to dynamically use the column headers when copying right. Excellent! Thanks and Thumbs up!
This is fantastic; thank you for your easy to follow instructions. How would you add a horizontal scroll to this to have both vertical and horizontal scroll bars?
Great one!
Wow,clearly explained, thanks , i always admire indian people ,they are genius
Deepak Eduworld @Youtube ko kuch pata nahi bas bakar bakar karta he
sir aapko koto bahut kuch aata he ! Thanks for Easy Understanding
sir mujhe scrollable cell chahiye lekin Ek Newsscroller ki tarah
means, Automatically ek Range se Cell Value lekar, Automatically Scroll karta rahe
dhire dhire slow speed me, Direction : Upwards, Speed: Slow, From : Bottom
kya sambhav he ? Well i know this is possible !
you 're excellent at excel and teaching, i think you're some computer teacher !
Thank you sir for such an incredible tutorial! Keep up the great work!
How can I use this to scroll through sheets like in your call center dashboard template?
Super Helpful trick
Informative
It doesn't work for huge data sets as it's too slow to load and my clients won't like it this way. May be if there's a faster method then please let me know.
Well thanks a lot Trump Excel.
i swear bruh this step F me up during the excel exam because it told me to use vertical scroll and add some shape color or whatever and the next step would write a sentence inside it and i didnt know how to do vertical scroll and that would prevent me from doing the other step so i submit and i got 675 instead of above 700 which i could have
Very useful vedio thx bro..
Great tutorial!! Can you tie internal hyperlinks to this process? I tried, but the hyperlink stays attached to the position, not the data… Any help would be appreciated! Thanks again!!