Skip Locked Cells When Entering Data Across an Excel Row
Question details
The user wants to move between editable cells across an Excel row while skipping locked calculated cells.

- 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.
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.
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.
Select the cells users should be able to edit. To select separate ranges, hold Ctrl while selecting each range.
Right-click the selection and choose Format Cells. On the Protection tab, clear Locked and select OK.
Open Review > Protect Sheet. Clear Select locked cells and leave Select unlocked cells checked. Set a password if needed, then confirm the protection settings.
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.

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. Open the workbook: Open your Excel workbook in WPS Spreadsheet and select the cells intended for data entry.
- 2. Unlock the input cells: Right-click the selected cells, choose Format Cells, and clear Locked on the Protection tab.
- 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. 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.

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.




