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

Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions.

Check out Excel Conditional Formatting today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Controlling Display of the Scroll Bars