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. <br /><br />These are the steps outlined in the video. <br /><br />Enable Developer Ribbon <br />1) Right-click anywhere in the ribbon <br />2) Customized the Ribbon... <br />3) Check on Developer <br />4) OK <br /><br />Here are the steps outlined in this video. <br />1) Ctrl+C <br />2) Ctrl+V <br />3) Developer ~ Control ~ Insert ~ Scroll Bar <br /> (under Form Controls) <br />4) Place Scroll Bar <br />5) Right-click scroll bar ~ Format Control... <br />6) Current Value set to 1 <br /> Minimum value set to 1 <br /> Maximum value set to 100 <br /> Cell Link to $J$2 <br />7) OK <br />8) Place cursor to F4 <br />9) =INDEX(A2:A$110,$J$2) <br />10) Drag cell F4 across until I4 <br />11) Drag cell again down 10 rows <br /><br />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, <br /><br />
