Fixing Scroll Bar Missing in Excel

RECOMMENDED: Click here to fix Windows errors and optimize system performance

By default, an Excel workbook displays a horizontal and vertical scroll bar to allow you to scroll through the spreadsheet data.

Scrolling in Excel refers to scrolling up, down or sideways through a worksheet with scroll bars, arrow keys on the keyboard or mouse scroll wheel. By default, Excel displays horizontal and vertical scroll bars at the bottom right of the Excel screen, but you can hide them.

Restore the scroll bar in Excel

  1. Click on the File menu, then on Options.
  2. From the sidebar, select Advanced.
  3. Scroll to the Display Options section of this workbook.
  4. Make sure that Display Horizontal Scroll Bar and Display Vertical Scroll Bar are selected.
  5. Click on OK.

Delete the Last Active Row

Since you cannot be sure that no other lines have been activated between the last line with good data and the last activated line, delete all lines under your data and the last activated line.

  1. Select the lines to be deleted. Select the line header with the mouse or press Shift+Space on the keyboard.
  2. Right-click on the header of one of the selected lines to open the context menu.
  3. Choose Delete to delete the selected lines.

September 2021 Update:

We now recommend using this tool for your error. Additionally, this tool fixes common computer errors, protects you against file loss, malware, hardware failures and optimizes your PC for maximum performance. You can fix your PC problems quickly and prevent others from happening with this software:

  • Step 1 : Download PC Repair & Optimizer Tool (Windows 10, 8, 7, XP, Vista – Microsoft Gold Certified).
  • Step 2 : Click “Start Scan” to find Windows registry issues that could be causing PC problems.
  • Step 3 : Click “Repair All” to fix all issues.


Maximize the scroll bar

If the scroll bar has been minimized to display a maximum number of cells, it is hidden until the process is reversed. Therefore, in this step, we will maximize the scroll bar. For that:

  1. Start Excel and open the spreadsheet where the scrolling is missing.
  2. At the bottom right, check that there are “Three horizontal points” next to the “Add” button.
  3. If the points are present, it means that the scroll bar has been reduced.
  4. Click and hold the “Three Horizontal Points” and drag them to the left to display the scroll bar again.

Arranging Tiles

There seems to be a bug with some versions of the program where the scroll bar could get lost if the tiles are not arranged. That is why we will arrange the tiles in this step. For that:

  1. Click on the “View” tab and select the “Arrange All” option.
  2. Click on “Tile” and select “OK” to save your changes.
  3. Check if the problem persists.

RECOMMENDED: Click here to troubleshoot Windows errors and optimize system performance