Quick answer: in Excel for Windows, go to File > Options > Advanced, scroll to the display options for this workbook and select Show horizontal scroll bar and Show vertical scroll bar, then select OK (the labels may differ slightly on your version). Microsoft describes this as a per-workbook setting, so a file you received may have it turned off even if your other files look fine. If the boxes are already selected, Windows may be hiding scroll bars until you move the mouse, or the Excel window may be too large for the screen.
In this guide
- Match your symptom
- Fix 1: Turn the scroll bars back on in Excel Options
- Fix 2: Stop Windows from hiding scroll bars
- Fix 3: Maximize and restore the Excel window
- Fix 4: Drag the sheet tabs out of the way
- Fix 5: Scroll bar is there but tiny or jumpy
- Fix 6: A macro or template keeps hiding them
- Excel for Mac
- Frequently asked questions
- Related guides
Applies to: Excel for Microsoft 365, Excel 2024 and Excel 2021 on Windows 11 and Windows 10, plus a short section for Excel for Mac. Microsoft’s scroll bar pages also list Excel 2019 and 2016, where the steps may differ slightly. If the scroll bars are there but the arrow keys scroll the sheet instead of moving between cells, see Excel arrow keys not working instead; that may be Scroll Lock rather than a missing scroll bar.
Match your symptom
Use this table to jump to the fix that matches what you see. Each row is one possibility to check, not a diagnosis.
| What you see | Possible cause | Go to |
|---|---|---|
| Both scroll bars gone in one workbook only | Scroll bars turned off for that workbook | Fix 1 |
| Scroll bars appear only when you move the mouse | Windows hides scroll bars automatically | Fix 2 |
| Right or bottom edge of the sheet cut off | Excel window larger than the screen | Fix 3 |
| Horizontal bar missing, sheet tabs fill the bottom row | Sheet tab area widened over the scroll bar | Fix 4 |
| Scroll box tiny, small drags jump thousands of rows | Used range much larger than your data | Fix 5 |
| Bars come back but vanish when the file reopens | A macro or template that hides them | Fix 6 |
Fix 1: Turn the scroll bars back on in Excel Options
Microsoft’s Hide or display scroll bars in a workbook page explains that Excel shows both scroll bars by default and that you can switch each one off or on for a workbook. To turn them back on:
- Open the workbook that’s missing its scroll bars.
- Select File, then Options.
- Select the Advanced category.
- Scroll down to the display options for this workbook. If several workbooks are open, the heading may show a workbook’s name; make sure it’s the file you want to change.
- Select Show horizontal scroll bar and Show vertical scroll bar, then select OK.
Microsoft’s Show scroll bars in Word or Excel page gives these checkbox names; the wording may differ slightly on your version. Because the choice is stored per workbook, save the file once the bars are back so they’re there the next time you open it.
If the File tab isn’t visible either, the ribbon may be collapsed. Double-clicking any ribbon tab name may bring the full ribbon back.
Fix 2: Stop Windows from hiding scroll bars
Windows may hide scroll bars in apps until you move the pointer over them, which can make Excel look as if it has none. Microsoft’s Show scroll bars page gives the Windows 10 path: Start > Settings > Ease of Access > Display, then set Automatically hide scroll bars in Windows to Off.
In Windows 11, the matching switch may be called Always show scrollbars and sit under Settings > Accessibility > Visual effects; turn it on. The name and location may vary between Windows 11 releases, so searching Settings for “scroll” is a quick way to find it.
This setting should change how scroll bars look in every app, not just Excel. If you prefer the thinner auto-hiding bars elsewhere, you can turn it back off once you’ve confirmed the bars were only hidden.
Fix 3: Maximize and restore the Excel window
If the Excel window is larger than the screen, the vertical bar on the right or the horizontal bar at the bottom may sit off the edge of the display. This may happen after you unplug a second monitor or change the display resolution or scale.
Microsoft’s Show scroll bars page suggests right-clicking the title bar and selecting Maximize, then right-clicking the title bar again and selecting Restore. Maximizing fits the window to the screen, so both bars should come back into view. Double-clicking the title bar may also switch between the two sizes.
If the workbook window inside Excel is not maximized (for example, you see a second set of minimize and close buttons below the ribbon), the bars may belong to that inner window. Maximizing the workbook window may bring them back.
Fix 4: Drag the sheet tabs out of the way
In Excel for Windows, the sheet tabs and the horizontal scroll bar usually share the bottom row of the window. A small handle between them may let you give more room to one or the other. If the tab area has been dragged all the way to the right, the horizontal scroll bar may shrink until it seems to disappear, while the vertical one is still there.
- Look at the right end of the sheet tabs for a small handle, often shown as three dots or a short vertical bar.
- Point at it until the pointer changes to a two-headed arrow.
- Drag it to the left. The horizontal scroll bar should widen as the tab area shrinks.
The handle may look different in your version of Excel. If you don’t see one, Fix 1 and Fix 3 are the better places to look.
Fix 5: Scroll bar is there but tiny or jumpy
Sometimes the bar isn’t missing, but the scroll box in it is so small that it’s hard to see or grab, and a small drag jumps far past your data. The scroll box may shrink when Excel treats a much larger area as used than your data fills, for example because of formatting or a stray entry far below your data.
- Press Ctrl + End. Excel should move to the last cell it considers used.
- If that cell is far beyond your real data, select the empty rows below your data, right-click and select Delete. Do the same for empty columns to the right if needed.
- Save the workbook, then close and reopen it. Excel may only recalculate the used area after a save.
Before you delete: check that the rows and columns really are empty. Hidden rows, white text or objects such as charts may sit in that area, and deleting the rows removes them too. Making a copy of the file first is a safe way to test.
Fix 6: A macro or template keeps hiding them
If you turn the scroll bars on, save, and they vanish again when the file reopens, something may be switching them off. Workbooks that act as forms or dashboards sometimes hide scroll bars on purpose, using a macro that runs when the file opens or a template the file was built from.
In VBA, scroll bars are usually controlled through window properties named DisplayHorizontalScrollBar and DisplayVerticalScrollBar. To check, press Alt + F11, which should open the Visual Basic Editor, and search the project for these names. A line setting one of them to False would hide that bar. To show both bars for the active window, you can run these lines in the Immediate window (Ctrl + G may open it):
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.DisplayVerticalScrollBar = True
Only change macros in workbooks you own or that you’ve been asked to maintain. If the file comes from a colleague or a template your team uses, ask its owner first, since the hidden bars may be intended.
Excel for Mac
On a Mac, Microsoft’s Show scroll bars page lists two places to check:
- macOS setting: Apple menu, then System Preferences > General, and under Show scroll bars select Always. Newer macOS versions call the app System Settings, so the path may look slightly different.
- Excel setting: select Excel > Preferences > View on the menu bar, then select Horizontal scroll bar and Vertical scroll bar.
If the window is in full screen and a bar is cut off, Microsoft’s page suggests leaving and reentering full screen with the green button, or pressing Command + Control + F.
Frequently asked questions
Why are the scroll bars missing in only one file?
Because Microsoft describes the setting as belonging to the workbook, not to Excel as a whole. A file created or saved by someone who had the bars turned off may open without them on your PC, while your other files look normal. Fix 1 turns them on for that file.
My mouse wheel scrolls Excel by itself. Is that related?
Usually not. Scrolling on its own points to a mouse or Windows input problem rather than a hidden scroll bar. Our guide to stopping automatic scrolling in Windows covers it. If Excel freezes while you scroll, see Excel not responding.
None of the fixes worked. What next?
Try opening the workbook on another PC or in Excel for the web to see whether the problem follows the file. If every workbook is affected and the options in Fix 1 don’t stick, an Office repair may help.
Related guides
- Excel arrow keys not working: how to fix it on Windows 11
- How to stop automatic scroll down in Windows 10 (7 fixes)
- Excel not responding: how to fix freezes and hangs
- How to repair Microsoft Office (Quick Repair and Online Repair)
- Excel tips and tricks: 10 ways to work faster in Excel
Leave a Reply