Normally, Excel worksheets display scroll bars at the bottom and on the right side of the program window. The vertical scroll bar allows you to scroll up or down the worksheet to view data that’s currently not visible on the screen, and the horizontal scroll bar lets you scroll from left to right and vice versa. The scroll bars are compact and take up very little onscreen space to allow more room for the work area. But if, for any reason you want to increase or decrease the size of the scroll bar, this Excel 2010 tutorial will show you how to modify the size of the scroll bar.
How to Modify the Size of the Scroll Bar
1. Right-click the desktop and choose Personalize.
2. At the bottom of the Personalization window, click Window Color.
3. In the Window Color and Appearance window, click Advanced appearance settings.
4. In the Window Color and Appearance dialog box, from the Item drop-down menu choose Scrollbar.
5. In the Size spin box, click the up or down arrow to increase or decrease the size of the vertical scroll bar in Windows. This will automatically have the effect of modifying the size of the scroll bar in Excel.
5. Click OK to close the dialog box.
That’s it. the next time you launch Excel you can see the changes that you made applied to the vertical scroll bar. This tutorial also holds good for Word 2010, and you’ll notice the changes when you open a Word document too.
Have you felt the need to modify the size of the vertical scroll bar in Excel? Do you have an Excel 2010 tip that you’d like to share with us? Drop us an email at firstname.lastname@example.org with your tip and we’ll share it with our readers.