Excel Center Over Selection? Fix It in 5 Steps

Errors & fixes · Updated November 22, 2026

The short answer: if your Excel selection keeps jumping back to the center of the screen when you click a cell, you’re likely experiencing a known display bug caused by the “Show sheet tabs” or “Show horizontal scroll bar” settings being toggled, or a graphics driver issue. The fix is usually to reset the view settings, update your graphics driver, or disable hardware graphics acceleration.

What “Center Over Selection” Actually Means

In Excel, “center over selection” isn’t a built-in feature or a toggle you can turn on. Instead, it’s a symptom: when you click a cell, the viewport automatically re-centers so that the selected cell appears in the middle of the screen, rather than staying where it was. This is different from the normal behavior where Excel keeps the selected cell in place unless you scroll. The term is often used in user forums to describe the annoyance of the screen jumping around, making it hard to work with large datasets.

Why Does Excel Keep Centering on the Selection?

Several factors can cause this behavior, and it’s rarely a single cause. The most common reasons include:

  • Graphics driver issues: Outdated or incompatible graphics drivers can cause rendering glitches, making Excel redraw the screen and center the selection.
  • Hardware graphics acceleration: Excel has a setting that uses your GPU to render the interface. When this is enabled and your GPU driver is buggy, it can cause erratic scrolling and centering.
  • Sheet tab or scroll bar visibility: Toggling “Show sheet tabs” or “Show horizontal scroll bar” off and on can sometimes trigger a view refresh that centers the selection.
  • Add-ins: Third-party add-ins, especially those that monitor selection changes, can force the view to recenter.
  • Zoom or freeze panes: If you have freeze panes active and you click a cell far from the frozen area, Excel may scroll to bring it into view, which can feel like centering.

How to Stop Excel from Centering on Selection

Here are the steps to fix the issue, in order of likelihood. Try them one by one until the problem stops.

  1. Disable hardware graphics acceleration: Go to File > Options > Advanced. Under the Display section, check the box for “Disable hardware graphics acceleration”. Click OK and restart Excel. This is the most common fix.
  2. Update your graphics driver: Visit your GPU manufacturer’s website (NVIDIA, AMD, Intel) and download the latest driver for your model. After updating, restart your computer and test Excel.
  3. Reset the view settings: Go to View > Workbook Views and switch to Normal (if you’re in Page Layout or Page Break Preview). Also, ensure that “Show sheet tabs” and “Show horizontal scroll bar” are both checked under File > Options > Advanced > Display options for this workbook.
  4. Check for add-ins: Go to File > Options > Add-ins. At the bottom, select “COM Add-ins” from the dropdown and click “Go”. Uncheck any add-ins you don’t need, especially ones that interact with selection. Restart Excel.
  5. Repair Office: If nothing works, repair your Office installation via Control Panel > Programs > Programs and Features, select Microsoft 365, and click “Change” then “Quick Repair”. If that fails, try “Online Repair”.

Common Misconception: It’s a Feature

Some users think “center over selection” is a deliberate Excel feature to help you see the active cell. That’s not true. Excel’s normal behavior is to keep the viewport static unless you scroll. The centering is almost always an unintended side effect of a rendering bug. So if you see it happening, you don’t need to “turn it off” – you need to fix the underlying issue.

How to Prevent It from Happening Again

Once you’ve fixed the centering, here are some habits to avoid recurrence:

  • Keep your graphics drivers updated regularly, especially after Windows updates.
  • If you use a laptop with switchable graphics (e.g., Intel integrated + NVIDIA discrete), set Excel to use the high-performance GPU in your graphics control panel.
  • Periodically clear the Excel cache: close Excel, press Win+R, type %appdata%\Microsoft\Excel, and delete the contents of the XLSTART folder (but back up any files there first).
  • Avoid toggling the sheet tab and scroll bar visibility settings frequently – it’s a known trigger for the bug.

Frequently Asked Questions

Why does my Excel jump to the center when I click a cell, but only on some worksheets?

This often happens when those worksheets have freeze panes applied. If you have freeze panes, clicking a cell outside the frozen area will scroll the view to bring it into view, which can look like centering. Remove freeze panes (View > Freeze Panes > Unfreeze Panes) to test if that’s the cause.

Does this happen in Excel for Mac or Excel for the web?

Yes, similar behavior has been reported on Mac and Excel for the web, but the fix differs slightly. On Mac, go to Excel > Preferences > View and uncheck “Use hardware graphics acceleration”. On Excel for the web, there is no hardware acceleration setting, so the issue is usually browser-related – try a different browser or disable browser hardware acceleration.

Can a VBA macro cause the selection to center?

Yes. If you have a macro that uses Application.Goto or Range.Select with the Scroll parameter, it can force the view to center. Check your macros for code like Application.Goto Reference:=Range("A1"), Scroll:=True. If you find it, remove the Scroll:=True argument. Remember to save a copy of your workbook before running any macro that changes the view.

Is there a keyboard shortcut to stop the centering?

No, there’s no direct shortcut. The centering is a rendering issue, not a toggle. However, pressing Ctrl+Home will take you to A1 and might reset the view temporarily. On Mac, it’s Fn+Ctrl+Left Arrow.

Will reinstalling Excel fix it?

Reinstalling Excel can help if the problem is due to corrupted program files, but it’s rarely necessary. Try the steps in this article first, especially the hardware acceleration disable, which resolves the majority of cases. If you do reinstall, back up your personal macros and customizations first.

When to Consider a Different Spreadsheet App

If you’ve tried all the fixes and the centering persists, and it’s severely impacting your work, you might consider using Google Sheets or LibreOffice Calc for your heavy spreadsheet tasks. These apps don’t have the same rendering bug. However, they lack some advanced Excel features like Power Query and complex array functions. Weigh the trade-offs: if you rely on Excel-specific formulas, it’s worth troubleshooting further; if you mostly do basic data entry, switching might be simpler.

In summary, the “center over selection” behavior is a fixable annoyance, not a built-in feature. Start with disabling hardware acceleration, update your drivers, and check your add-ins. With a few minutes of troubleshooting, you’ll likely have your spreadsheet view back to normal.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.