Controlling Display of the Scroll Bars

Summary: Turning off the scroll bars through the options menu. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

At the bottom and right side of the worksheet there are scroll bars that control what part of the spreadsheet you are viewing at any given time. If you need more room to view a worksheet, or if you are using Excel without a mouse, you can turn them off. To control display of the scroll bars, follow these steps:

Choose Options from the Tools menu. You will see the Options dialog box.
Make sure the View tab is selected. (Click here to see a related figure.)
In the Window Options area, clear the Horizontal Scroll Bar check box if you want the horizontal scroll bar removed.
In the Windows Options area, clear the Vertical Scroll Bar check box if you want the vertical scroll bar removed.
Click on OK.

With the scroll bars turned off, you must use the cursor control keys to move through the worksheet.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2644) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Don't Go in Debt for Christmas! Tired of trying to keep up with the Joneses for Christmas? Want to enjoy the season rather than dread the aftermath? Learn how you can avoid the financial traps that spring up every Christmas.

Check out Top Fifteen Tips for Financing Christmas today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Controlling Display of the Scroll Bars