Permission & Access Issues

Skip Locked Cells When Entering Data Across an Excel Row

Adam DavisAdam Davis Nov 18, 2026 868 views

Question details

The user wants to move between editable cells across an Excel row while skipping locked calculated cells.

Skip Locked Cells When Entering Data Across an Excel Row
Product
Microsoft Excel
Device & OS
not provided
Scenario
Users enter data in designated input cells on a worksheet that also contains calculated cells.
Observed behavior
Worksheet protection can restrict selection to input cells, but it may change how Tab and Enter move between cells.
Before you start

Identify the input cells users should edit and check that calculated cells remain locked. If the sheet is already protected, unprotect it from the Review tab before changing cell protection settings.

Solution 1Recommended

Protect the Excel Sheet and Allow Selection of Unlocked Cells

Use worksheet protection to keep calculated cells inaccessible while users move between editable input cells.

1
Select the input cells

Select the cells users should be able to edit. To select separate ranges, hold Ctrl while selecting each range.

2
Unlock the input cells

Right-click the selection and choose Format Cells. On the Protection tab, clear Locked and select OK.

3
Protect the worksheet

Open Review > Protect Sheet. Clear Select locked cells and leave Select unlocked cells checked. Set a password if needed, then confirm the protection settings.

4
Test data entry

Select an unlocked input cell and press Tab to move through permitted cells. Test Enter as well, since its movement may differ from Tab or from the unprotected sheet.

Protect the Excel Sheet and Allow Selection of Unlocked Cells
Movement may change: Protection restricts selection to unlocked cells, but it does not guarantee the same Tab or Enter movement as an unprotected sheet. Tab is generally the better choice for moving across a row.
WPS Spreadsheet

Skip Locked Cells in WPS Spreadsheet

Use cell and worksheet protection in WPS Spreadsheet to keep calculated cells locked and let users select only designated input cells.

  1. 1. Open the workbook: Open your Excel workbook in WPS Spreadsheet and select the cells intended for data entry.
  2. 2. Unlock the input cells: Right-click the selected cells, choose Format Cells, and clear Locked on the Protection tab.
  3. 3. Protect the sheet: Choose Review > Protect Sheet. In the protection options, clear Select locked cells and leave Select unlocked cells enabled, then confirm.
  4. 4. Check navigation: Select an input cell and press Tab to check that selection moves among unlocked cells. Test Enter separately because its movement may differ.
Move between unlocked input cells while skipping locked cellsProtect formulas and calculated cells from ordinary editingWork with Microsoft Excel formats such as XLSX and XLSUse familiar spreadsheet menus for formatting and protection
microsoft office alternative - wps office

Frequently Asked Questions

Why can I still select locked cells after protecting the sheet?

On the Review tab, unprotect the sheet and choose Protect Sheet again. Clear Select locked cells and leave Select unlocked cells enabled before confirming.

Why can't users edit the input cells?

Unprotect the sheet from Review, select the input cells, and open Format Cells > Protection. Clear Locked, then protect the sheet again.

Will Enter move across the row like Tab?

Not necessarily. Enter and Tab can move in different directions, and sheet protection can change their navigation. Use Tab for moving across input cells and test the behavior on the protected sheet.

Can I skip locked cells without protecting the worksheet?

The Locked setting takes effect when the worksheet is protected. To prevent selection of locked cells, use Review > Protect Sheet and clear Select locked cells.