Hide or display scroll bars in a workbook

By default, a horizontal and vertical scroll bar are displayed in an Excel workbook so that you can scroll through the data in its worksheets. However, you can turn scroll bars on or off as needed.

2016, 2013, 2010 2007



1. Click the File tab.

2. Click Options, and then click the Advanced category.

3. Under Display options for this workbook, clear or select the Show horizontal scroll bar check box and Show vertical scroll bar check box to hide or display the scroll bars.

1. Click the Microsoft Office Button , and then click Excel Options.

2. In the Advanced category, under Display options for this workbook, clear or select the Show horizontal scroll bar check box and Show vertical scroll bar check box to hide or display the scroll bars.