Fix a Missing Horizontal Scroll Bar in Saved Excel Workbooks
Question details
The user needs to restore the horizontal scroll bar in saved Excel workbooks.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The horizontal scroll bar appears in new workbooks but is missing when saved workbooks are opened.
- Observed behavior
- Saved workbooks lack the horizontal scroll bar, while full-screen mode makes it appear but hides headers and other top information.
Open an affected workbook in Excel and check whether the scroll bar is missing at the bottom of its window. If multiple workbooks are open, note the affected workbook's name so you can select it in Excel's display options.
Enable Scroll Bars for the Affected Excel Workbook
Use this method when scroll bars appear in new workbooks but are hidden in a saved workbook.
With the affected workbook open, select File > Options > Advanced.
Scroll to Display options for this workbook and choose the affected workbook from the dropdown if necessary.
Select Show horizontal scroll bar and, if needed, Show vertical scroll bar. Click OK.
Check the bottom of the workbook window for the horizontal scroll bar, then select File > Save to save the workbook.

Adjust the Excel Workbook Window and Scroll Bar Area
Use this method if the display options are enabled but the horizontal scroll bar is still not visible.
Open and Navigate Excel Workbooks in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets for an easy transition, though it does not change Excel's own scroll bar settings.

Frequently Asked Questions
Why does the scroll bar appear in a new workbook but not a saved one?
Scroll bar visibility can be set for an individual workbook. Open the affected file and check File > Options > Advanced > Display options for this workbook.
Where is the horizontal scroll bar setting in Excel 2016?
Select File > Options > Advanced, then find Display options for this workbook and select Show horizontal scroll bar.
What if the horizontal scroll bar is enabled but still missing?
Look for a divider or three-dot handle beside the sheet tabs and drag it left. Also maximize the Excel window and check whether workbook protection is restricting layout changes.
How do I leave full-screen mode without losing the workbook?
Press Esc to return to the normal Excel view. Then check the workbook display options if the scroll bar disappears again.




