Restore Missing Horizontal and Vertical Scroll Bars in Excel
Question details
Restore the horizontal and vertical scroll bars in Excel when they remain hidden despite being enabled in the display settings.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- The user wants to navigate an Excel workbook using its horizontal and vertical scroll bars.
- Observed behavior
- Both scroll bars remain hidden after their display options are enabled.
Confirm which workbook is affected and close Excel before repairing Office. Online Repair requires an internet connection and may require administrator permission.
Repair Microsoft Office and recheck Excel scroll bar settings
Use Online Repair when the scroll bars remain hidden even though the workbook display options are enabled.
Close Excel, open Control Panel, and select Programs > Programs and Features.
Select Microsoft 365 or Microsoft Office in the installed programs list, then click Change. Approve the permission prompt if one appears.
Select Online Repair, click Repair, and follow the prompts. Wait for the repair to finish.
Reopen Excel and the affected workbook. Go to File > Options > Advanced, find Display options for this workbook, and confirm that Show horizontal scroll bar and Show vertical scroll bar are selected.

Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative for opening and editing spreadsheets in a familiar interface. It supports common Excel formats, making it easier to move your files between applications, although it does not repair Excel itself.

Frequently Asked Questions
Where are the Excel scroll bar settings?
Open the affected workbook and go to File > Options > Advanced. Under Display options for this workbook, select Show horizontal scroll bar and Show vertical scroll bar.
What if both scroll bar options are already selected?
Close Excel and repair Office through Control Panel > Programs > Programs and Features. Select Microsoft 365 or Microsoft Office, click Change, and choose Online Repair if it is available.
Does Online Repair need an internet connection?
Yes. Connect to the internet before selecting Online Repair in the Office repair window. The available repair options can vary by installation.
Can WPS Office repair missing scroll bars in Microsoft Excel?
No. Use the Microsoft Office repair tools to address the Excel installation. WPS Spreadsheets is a separate application that can open common Excel files, including XLS and XLSX.




