sodcalculator

10 Tech How-To

Excel Not Scrolling Smoothly? Fixes That Work

Guide 10-10853 · Updated · Step by step

If your Excel worksheet stutters, jumps, or freezes when you scroll, the fix is usually one of a few settings: turning off hardware graphics acceleration, disabling add-ins, or checking freeze panes and page break views. This guide walks through the most common causes and the exact steps to restore smooth scrolling in Excel on Windows.

Why Excel Scrolling Gets Choppy

Excel renders the visible grid constantly as you scroll. When that rendering slows down, you see lag, flicker, or the view jumps in large steps. The main culprits are:

  • Hardware graphics acceleration – Excel uses your GPU to draw cells; a driver conflict or old graphics driver makes this slow.
  • Add-ins – Third-party add-ins (like data connectors or PDF tools) run code during scrolling.
  • Freeze Panes – Frozen rows/columns force Excel to redraw more area per scroll tick.
  • Page Break Preview – This view recalculates page breaks constantly.
  • Large volatile formulas – Formulas like OFFSET, INDIRECT, or TODAY recalc on every scroll event.
  • Conditional formatting rules – Many rules over a large range slow redraw.

Fix 1: Turn Off Hardware Graphics Acceleration

This is the single most effective fix for scroll lag on Windows laptops and desktops with integrated graphics.

  1. Open Excel, go to File > Options.
  2. Select Advanced in the left pane.
  3. Scroll down to the Display section.
  4. Check the box Disable hardware graphics acceleration.
  5. Click OK and restart Excel.

If the lag disappears, the issue was GPU rendering. You can keep it off or update your graphics driver (see Fix 5).

Fix 2: Disable Add-Ins

Add-ins load in the background and can intercept scroll events. To test:

  1. Go to File > Options > Add-ins.
  2. At the bottom, set Manage to COM Add-ins and click Go.
  3. Uncheck all boxes, click OK, restart Excel.
  4. If scrolling is smooth, re-enable add-ins one by one to find the culprit.

Common offenders are PDF converters, screen capture tools, and older data analysis add-ins. You can also run Excel in Safe Mode (hold Ctrl while launching) – if scrolling works there, an add-in is the cause.

Fix 3: Check Freeze Panes and View Mode

Frozen panes keep rows/columns visible but force Excel to redraw them on every scroll movement. To check:

  1. Go to View tab.
  2. Click Freeze Panes – if it says Unfreeze Panes, click that.
  3. Also switch from Page Break Preview to Normal view (bottom-right status bar icons).

If you need frozen headers, a lighter alternative is to use a Table (Ctrl+T) – its header row stays visible without the same redraw cost.

Fix 4: Reduce Volatile Formulas and Conditional Formatting

Volatile formulas recalculate whenever Excel redraws. Replace them where possible:

  • Replace OFFSET with INDEX (non-volatile).
  • Replace INDIRECT with direct cell references or named ranges.
  • Use NOW() or TODAY() only where truly needed – they recalc on every change.
  • For conditional formatting, apply rules to the used range, not entire columns (e.g., A1:A1000 instead of A:A).

To see if formulas are the issue, set calculation to manual (Formulas > Calculation Options > Manual) and scroll. If smooth, the formulas are the bottleneck.

Fix 5: Update Graphics Drivers and Windows

Outdated or corrupted GPU drivers are a common cause of hardware acceleration problems.

  1. Press Win + X and select Device Manager.
  2. Expand Display adapters, right-click your GPU, choose Update driver.
  3. Select Search automatically – or visit the manufacturer’s site (Intel, AMD, NVIDIA) for the latest version.
  4. Also run Windows Update to install any pending OS patches.

After updating, re-enable hardware acceleration in Excel (Fix 1) and test.

Fix 6: Disable Smooth Scrolling (Excel 365/2021)

Newer Excel versions have a “smooth scrolling” feature that animates the view. On some machines it feels worse than the classic jump-scroll.

  1. Go to File > Options > Advanced.
  2. Under Display, uncheck Enable smooth scrolling.
  3. Click OK and test.

This is a personal preference – some users find the animation pleasant, others find it laggy. Turning it off gives the old instant-jump behavior.

Fix 7: Check for Large Used Range

If your sheet has formatting applied to hundreds of thousands of empty rows, Excel still tracks them. To check:

  1. Press Ctrl+End – this jumps to the last used cell. If it’s far beyond your data, you have a bloated range.
  2. Select the empty rows/columns, right-click and choose Delete (not just clear).
  3. Save the file – this often shrinks the used range.

Alternatively, copy the entire used range and paste into a new workbook – this resets all internal tracking.

Frequently Asked Questions

Why does Excel scroll slowly only in one file?

That points to file-specific content: volatile formulas, conditional formatting, defined names with errors, or a huge used range. Open a blank workbook – if it scrolls fine, the issue is in that file’s data or formatting.

Does my mouse wheel settings affect Excel scrolling?

Yes. Windows mouse settings control how many lines scroll per notch. If set to “One screen at a time,” Excel will jump. Go to Settings > Bluetooth & devices > Mouse and set “Roll the mouse wheel to scroll” to a small number of lines (like 3).

Is there a keyboard shortcut to scroll without lag?

Use Page Down/Up or the arrow keys – these don’t trigger the same redraw as wheel scrolling. Ctrl+Arrow jumps to data edges. For large datasets, use the scroll bar drag instead of the wheel.

Will disabling hardware acceleration affect other Office apps?

No – the setting is per-application. You can disable it in Word or PowerPoint separately if they also lag, but it won’t change Excel’s behavior.

Why does Excel scroll fine in Safe Mode but not normally?

Safe Mode disables all add-ins and customizations. If scrolling is smooth there, an add-in is the cause. Use Fix 2 to identify which one.

Does the file being on a network drive cause scroll lag?

Sometimes. If the file is on a slow network share, Excel may wait for the file to sync. Copy the file locally and test. If smooth, move your working copy to the local drive or use a faster connection.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →