Excel scroll bar missing: how to get it back

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.

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 seePossible causeGo to
Both scroll bars gone in one workbook onlyScroll bars turned off for that workbookFix 1
Scroll bars appear only when you move the mouseWindows hides scroll bars automaticallyFix 2
Right or bottom edge of the sheet cut offExcel window larger than the screenFix 3
Horizontal bar missing, sheet tabs fill the bottom rowSheet tab area widened over the scroll barFix 4
Scroll box tiny, small drags jump thousands of rowsUsed range much larger than your dataFix 5
Bars come back but vanish when the file reopensA macro or template that hides themFix 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:

  1. Open the workbook that’s missing its scroll bars.
  2. Select File, then Options.
  3. Select the Advanced category.
  4. 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.
  5. 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.

  1. Look at the right end of the sheet tabs for a small handle, often shown as three dots or a short vertical bar.
  2. Point at it until the pointer changes to a two-headed arrow.
  3. 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.

  1. Press Ctrl + End. Excel should move to the last cell it considers used.
  2. 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.
  3. 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.

Sources

How we write our guides: read our editorial policy.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *