WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to lock cells in WPS Spreadsheet

February 13, 2023
15.0K Views

1. Use WPS Office to open or create a new table, then select the operated cells.

2. Click the Review tab click the Lock Cell button in turn.

(Note: Only if the worksheet is protected, the Lock Cell feature can protect data from being modified.)

3. Click Protect Worksheet. Then the Protect Sheet dialog box will pop up.

4. Set a password according to our needs in the Protect Worksheet popup box, and check Select locked cells and Select unlocked cells.

5. Finally, click OK.

(Note: We can also check other options according to our needs.)

6. Now we have successfully locked the selected cell.

If you want to learn more, you are welcome to join our WPS Academy to watch more related videos.

This skill could also be used in Microsoft Office Excel and OpenOffice.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.