Office Settings & Configuration

Fix a Missing Horizontal Scroll Bar in Saved Excel Workbooks

Huma Ashraf ChHuma Ashraf Ch Nov 20, 2026 869 views

Question details

The user needs to restore the horizontal scroll bar in saved Excel workbooks.

Fix a Missing 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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel options

With the affected workbook open, select File > Options > Advanced.

2
Select the workbook

Scroll to Display options for this workbook and choose the affected workbook from the dropdown if necessary.

3
Enable the scroll bars

Select Show horizontal scroll bar and, if needed, Show vertical scroll bar. Click OK.

4
Save and check

Check the bottom of the workbook window for the horizontal scroll bar, then select File > Save to save the workbook.

Enable Scroll Bars for the Affected Excel Workbook
Free Microsoft Office alternative

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.

Navigate worksheets in a familiar spreadsheet interfaceCompatible with Microsoft Excel XLS and XLSX filesFree and lightweight for everyday spreadsheet workOpen existing workbooks without starting from scratch
QA img-9

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.