Thursday, January 28, 2021

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.

  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 Office button image , 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.

No comments:

Post a Comment