By default, a horizontal and vertical scroll bar are displayed in an Excel workbook (workbook: A spreadsheet program file that you create in Excel. A workbook contains worksheets of rows and columns in which you can enter and calculate data.) so that you can scroll through the data in its worksheets (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.). However, you can turn scroll bars on or off as needed.
- Click the File tab.
- Click Options, and then click 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.