How to Protect a WPS Excel Worksheet While Allowing Input in Selected Cells
Question details
The user needs to protect an Excel worksheet so clients can enter names and addresses only in 33 designated cells while formulas, terms, conditions, and other content remain locked.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Creating a client-facing workbook that collects specific information without exposing or altering formulas and terms.
- Observed behavior
- The worksheet should remain protected except for 33 selected input cells that must stay editable for client data entry.
Make sure you have the workbook open in WPS Spreadsheets and know which cells or ranges should remain editable before you apply sheet protection. If the file was previously protected, use Review > Unprotect Sheet first.
Unlock Selected Input Cells and Protect the Worksheet
Use this method when you want full control over exactly which cells remain editable and which formulas or text stay locked.
Worksheet protection in WPS Spreadsheets only locks cells that have the Locked formatting option enabled. By clearing Locked for the 33 input cells before protecting, you keep those cells editable while everything else remains protected.
Open the workbook in WPS Spreadsheets, go to the Review tab, and click Unprotect Sheet if the sheet is currently protected. Enter the password if prompted.
Select the 33 designated cells where clients should enter names, addresses, and other information. Hold the Ctrl key to select multiple non-adjacent cells or drag to select a contiguous range.
Right-click the selected cells and choose Format Cells. In the Protection tab, clear the Locked checkbox and click OK.
Go to Review > Protect Sheet. Set a password if needed, confirm the actions you want to allow, and click OK.
Troubleshoot a Selected Cell That Remains Unavailable After Protection
Use this when the main unlock method does not make a particular cell editable, usually because of merged cells, data validation, or file-format issues.
Protect a Worksheet and Keep Selected Cells Editable in WPS Spreadsheets
WPS Spreadsheets lets you unlock only the cells clients need to fill in, then protect formulas, terms, and layout. It opens and saves Microsoft Excel workbooks so you can share the protected file with confidence.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office and open the .xlsx workbook you need to protect for client input.
- 2. Unlock the designated input cells: Select the 33 client input cells, right-click, choose Format Cells > Protection, and clear the Locked checkbox.
- 3. Protect the worksheet: Go to the Review tab, click Protect Sheet, set a password if required, and confirm the actions users are allowed to perform.
- 4. Test client input: Click one of the designated input cells and type sample data to verify it is editable, then click a protected formula cell to confirm it is locked.
Frequently Asked Questions
Why can I still not type in a cell after unlocking it and protecting the sheet?
Check whether the cell is part of a merged range, has a Data Validation rule, or the sheet is protected with different settings. In WPS Spreadsheets, unmerge the cell, review Data > Data Validation, and save the file as .xlsx if needed.
Can I allow different clients to edit different ranges in the same worksheet?
If your WPS Spreadsheets version includes Review > Allow Users to Edit Ranges, you can create named ranges with separate permissions before protecting the sheet. Otherwise, unlock all intended input ranges through Format Cells > Protection and protect the sheet once.
How do I select multiple non-adjacent input cells before clearing Locked?
Hold the Ctrl key while clicking each cell or range, then right-click any selected cell and choose Format Cells > Protection. Clear Locked and click OK.
Will my protected worksheet still work in Microsoft Excel?
Yes. Save the workbook as .xlsx. The protection and unlocked-cell settings are saved in the file, so users can open it in Microsoft Excel or WPS Spreadsheets and still edit only the designated cells.
