Others

How to Fix Excel Cell Selection Jumps on Protected Worksheets

Maira Mehtab Sep 27, 2026 869 views

Question details

The user experiences erratic cell selection jumps when navigating a protected worksheet with arrow keys, causing the selection cursor to skip over multiple cells.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Navigating between cells using keyboard arrow keys on a password-protected spreadsheet.
Observed behavior: Excel skips over locked cells and jumps directly to distant unlocked cells instead of moving to the adjacent cell.

Before you start

Ensure you have the worksheet protection password handy, as you will need to temporarily unprotect the sheet to modify the selection rules.

Solution 1Recommended

Adjust Worksheet Protection to Allow Selecting Locked Cells

This is the most common and direct fix. By allowing users to select locked cells, the arrow keys will navigate normally without skipping.

When Excel is configured to only allow selection of unlocked cells, pressing an arrow key forces the program to find the very next unlocked cell in that direction, no matter how far away it is. Changing the protection parameters restores standard navigation.

Unprotect the Worksheet

Go to the 'Review' tab on the Excel ribbon and click 'Unprotect Sheet'. Enter your password if prompted.

Open Protection Settings

Still on the 'Review' tab, click 'Protect Sheet' to open the protection options dialog box.

Enable Locked Cell Selection

In the list of allowed actions, ensure both 'Select locked cells' and 'Select unlocked cells' are checked.

Apply and Test

Re-enter your password to apply the protection, click 'OK', and use your arrow keys to verify the jumping behavior has stopped.

Data Remains Secure: Allowing users to select locked cells does not allow them to edit or delete the contents. Your formulas and data remain safely protected.

Solution 2

Unlock Specific Cells Required for Navigation

If you strictly want to prevent users from selecting locked cells, you must format the skipped cells as 'Unlocked' so the cursor can land on them.

Solution 3

Verify the VBA ScrollArea Property is Blank

Occasionally, erratic jumping is caused by a restrictive ScrollArea set via VBA rather than standard sheet protection.

Manage Sheet Protection Easily

Control Worksheet Protection Seamlessly with WPS Spreadsheet

WPS Office Spreadsheet provides a highly compatible and intuitive interface for managing worksheet protection, locking cells, and controlling user navigation without the hassle of unexpected cursor jumps.

1. Open Your Protected File: Launch WPS Spreadsheet and open your existing protected Excel workbook.
2. Access Protection Options: Navigate to the 'Review' tab on the top ribbon and click on 'Unprotect Sheet'.
3. Adjust Selection Rules: Click 'Protect Sheet', check the box for 'Select locked cells' in the permissions list, and click OK to resolve the jumping issue instantly.

Fully compatible with Microsoft Excel (.xlsx, .xls) formats and native protection settings.Clear, intuitive interface for managing cell locking and worksheet security.Free, lightweight, and fast alternative for professional spreadsheet management.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel skip locked cells on a protected sheet?

When a worksheet is protected and the permission 'Select locked cells' is unchecked, Excel prevents the selection cursor from landing on those cells. Consequently, using arrow keys forces the cursor to bypass the locked cells and jump to the nearest unlocked cell available in that direction.

Can I navigate locked cells without allowing users to edit them?

Yes. By checking the 'Select locked cells' permission when applying worksheet protection, users can click on and navigate through locked cells with arrow keys. However, any attempt to modify or delete the contents of those cells will still trigger a protection error.

Does removing worksheet protection affect my formulas?

No, unprotecting a worksheet solely removes the editing and selection restrictions. Your formulas, formatting, and data will remain perfectly intact. Just remember to reapply the protection once you are done making structural changes.

Office Quick Solutions