Office Settings & Configuration

How to Make Excel Scroll with the Selected Cell Using Arrow Keys

Chanuka Geekiyanage Sep 29, 2026 871 views

Question details

The user needs Excel to properly scroll and keep the selected cell visible when navigating a worksheet with arrow keys.

How to Make Excel Scroll with the Selected Cell When Using Arrow Keys

Product: Microsoft Excel
Device & OS: not provided
Scenario: Navigating a spreadsheet using arrow keys, especially after duplicating worksheets where display settings may have changed.
Observed behavior: The worksheet fails to scroll with the selected cell as expected, often due to cleared or incorrect Freeze Panes settings.

Before you start

Ensure that your keyboard's Scroll Lock is turned off, as having it enabled is a very common reason why arrow keys move the entire screen instead of jumping between individual cells.

Solution 1Recommended

Unfreeze or Reconfigure Panes

Modify the Freeze Panes settings to restore normal cell-by-cell scrolling behavior or to correctly keep specific headers visible while navigating.

When you duplicate a worksheet, Freeze Panes settings might not transfer correctly, causing unexpected scrolling behavior. Adjusting this setting ensures your selected cell stays visible when navigating with arrow keys.

Open the View Tab

Navigate to the View tab located on the Excel ribbon at the top of the window.

Locate Freeze Panes

Find the Window group within the View tab and click on the Freeze Panes drop-down menu.

Unfreeze the Worksheet

Select Unfreeze Panes to unlock all rows and columns. This allows the sheet to scroll normally with the selected cell.

Refreeze if Necessary

If you want headings to remain visible, reposition your active cell immediately below your headers and to the right of your row labels, then select Freeze Panes again.

Verify with a New Workbook: Test the arrow key behavior in a brand new workbook to confirm if the scrolling issue was isolated to the specific worksheet's layout.

Solution 2

Disable Scroll Lock on Your Keyboard

Turn off Scroll Lock if your arrow keys are moving the entire worksheet view instead of selecting individual cells.

WPS Spreadsheet Free Alternative

How to Manage Scrolling and Freeze Panes Seamlessly in WPS Office

WPS Office offers a highly compatible and user-friendly spreadsheet tool where managing frozen panes and scrolling behaviors works exactly as you expect. You can easily duplicate sheets while preserving your preferred layouts without unexpected scrolling bugs.

1. Open Your Workbook: Launch WPS Spreadsheet and open your existing file.
2. Navigate to the View Tab: Click on the View tab on the top menu ribbon.
3. Manage Freeze Panes: Click on Freeze Panes to either unfreeze your layout for normal scrolling or freeze specific rows and columns.
4. Navigate Smoothly: Use your arrow keys to verify the selected cell scrolls smoothly exactly as intended.

Completely free and lightweight office suiteFully compatible with Microsoft Excel (.xlsx, .xls) formatsIntuitive View tab for managing Freeze Panes seamlesslyTabbed interface to manage multiple open worksheets efficiently

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel sheet move instead of the selected cell?

This usually happens when Scroll Lock is enabled on your keyboard. When active, it causes the arrow keys to scroll the entire worksheet view instead of moving the selection between individual cells. Disabling Scroll Lock restores normal behavior.

Do Freeze Panes settings copy over when I duplicate a sheet?

Not always. Depending on how you duplicate or clear contents in a worksheet, the Freeze Panes configuration can get cleared. You may need to manually re-apply it by going to the View tab and selecting Freeze Panes.

How do I keep my top row visible while scrolling down?

Go to the View tab on the Excel ribbon, click on the Freeze Panes menu, and select Freeze Top Row. This locks the first row in place, allowing you to scroll through the rest of your data while keeping your headers visible.

Office App Problems