How to Modify the Size of the Scroll Bar in Excel 2010

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.

Personalize option

2. At the bottom of the Personalization window, click Window Color.

Window Color

3. In the Window Color and Appearance window, click Advanced appearance settings.

Advanced settings

4. In the Window Color and Appearance dialog box, from the Item drop-down menu choose Scrollbar.

How to Modify the Size of the Scroll Bar

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 editor@theapptimes.com with your tip and we’ll share it with our readers.

About Adeline Gear

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and games on android-resources.net.