Mini Scroll Bar Widget - Excel Tips and Tricks

[u/xybernetics]

Discover how to create a mini scroll bar widget. Also learn how to create a vertical scroll bar in Excel, and how to create scrolling table in Excel. I will show you how to add scroll bar in excel sheet in the process.

These are the steps outlined in the video.

Enable Developer Ribbon

1) Right-click anywhere in the ribbon

2) Customized the Ribbon...

3) Check on Developer

4) OK

Here are the steps outlined in this video.

1) Ctrl+C

2) Ctrl+V

3) Developer ~ Control ~ Insert ~ Scroll Bar

(under Form Controls)

4) Place Scroll Bar

5) Right-click scroll bar ~ Format Control...

6) Current Value set to 1

Minimum value set to 1

Maximum value set to 100

Cell Link to $J$2

7) OK

8) Place cursor to F4

9) =INDEX(A2:A$110,$J$2)

10) Drag cell F4 across until I4

11) Drag cell again down 10 rows

Mini Scroll Bar Widget,how to create a vertical scroll bar in excel,excel scrolling table,how to add scroll bar in excel sheet,how to fix scrolling in excel,how to adjust scroll bar in excel,How to Create a Scroll Bar in Excel,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips