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 a Spreadsheet in WPS Office (3 Common Ways)

February 18, 2024
5.6K Views

In the realm of digital data protection, this guide offers a succinct exploration of three prevalent methods to secure your WPS Office spreadsheet, equipping users with essential knowledge to safeguard sensitive information efficiently.

Part 1. How to Lock a Spreadsheet from Viewing or Editing?

Protecting your data in WPS Spreadsheet is crucial, and preventing unauthorized viewing and editing is key. Here's a step-by-step guide on achieving this:

Method 1: Protecting a Spreadsheet from Viewing

Step 1: Access Document Encryption:

  • Open the spreadsheet you want to protect in WPS Spreadsheet.

  • Click on the Menu button (usually located in the top-left corner).

Select Menu tab.


  • Select Options.

  • In the Options window, navigate to the Security tab.

Step 2: Set Document Password:

  • Under File encryption options for this workbook, locate the Document password field.

  • Enter a strong password that you'll remember.

  • Re-enter the password to confirm it.

  • Click OK.

Create password from security icon.


Step 3: Save Changes:

  • Save the spreadsheet

Method 2: Protecting a Spreadsheet from Editing

Step 1: Set Password to Modify:

  • With the spreadsheet open, click on the Review tab.

Select Review tab.


  • Click Protect Sheet.

Select Protect Sheet.


  • In the Protect Sheet dialog box, enter a password in the Password to modify field.

  • Select the desired protection options (e.g., allowing formatting, sorting, filtering).

  • Click OK.

Select OK


Step 2: Re-enter Password:

  • Re-enter the password then click OK.

Step 3: Save Changes:

  • Save the spreadsheet

Important Reminders:

  • Choose Strong Passwords: Select passwords that are difficult to guess and include a combination of letters, numbers, and symbols.

  • Keep Passwords Secure: Store passwords in a safe place and avoid sharing them with others.

  • Remove Protection if Needed: To remove password protection, access the same options and fields where you set the passwords and clear them.

  • Consider Additional Security Measures: For highly sensitive information, explore advanced security options within WPS or your operating system.

Part 2. How to Lock a Spreadsheet with Data Entry Allowed 

Method 1: Protecting Worksheet with Editable Ranges

Step 1: Select Cells to Remain Editable:

  • Highlight the cells you want users to be able to modify.

  • Right-click on the selected cells and choose Format Cells.

Step 2: Unlock Cells:

  • In the Format Cells dialog box, go to the Protection tab.

Select Protection from Format Cells


  • Uncheck the Locked box.

  • Click OK.

Step 3: Protect the Worksheet:

  • Click on the Review tab.

  • Click Protect Sheet.

  • Enter a password (optional but recommended).

  • Check the box for "Allow Users to Edit Ranges".

  • Click OK.

Step 4: Define Editable Ranges (if prompted):

  • If prompted, create a name for the editable range.

  • Click OK.

(Insert screenshot of the "Allow Users to Edit Ranges" checkbox)

Method 2: Protecting Specific Cells (if applicable)

  • Right-click on the cells you want to protect and choose Format Cells.

  • Check the Locked box in the Protection tab.

  • Protect the worksheet as described in Method 1.

Important Reminder:

  • Save the spreadsheet to apply the protection settings.

Additional Tips:

  • Use clear and concise language in your guide.

  • Number each step for easy reference.

  • Highlight important keywords in bold.

  • Add arrows or other visual cues to direct attention to specific areas in screenshots.

  • Test the protection settings thoroughly to ensure they work as intended.

Part 3. How to Lock a Spreadsheet: Password for Each Sheet

While sheet-level password protection in WPS is great, what if you need individual passwords for each sheet? It's possible, and this guide will show you how:

Step 1: Access Sheet Protection:

  • Open the spreadsheet in WPS Spreadsheet.

  • (Insert screenshot of the WPS Spreadsheet interface)

  • Click on the Review tab.

  • Locate the Protect Sheet button.

Select Protect Sheet.


Step 2: Set Password:

  • Click Protect Sheet.

  • (Insert screenshot of the Protect Sheet dialog box)

  • Enter a unique password for the current sheet in the Password to unprotect sheet field.

  • Re-enter the password to confirm it.

Enter password then click OK


Step 3: Select Protection Options (optional):

  • Choose which actions you want to allow users to perform on the protected sheet (e.g., selecting locked cells, formatting cells, inserting rows).

Step 4: Repeat for Each Sheet:

  • Navigate to the next sheet you want to protect.

  • Follow steps 2-3 to set a unique password and protection options for that sheet.

Step 5: Save Changes:

  • Save the spreadsheet to apply the password protection to each sheet.

Important Reminders:

  • Record Passwords: Keep a secure record of the passwords for each sheet.

  • Remove Protection: To remove password protection, access the Protect Sheet dialog box for each sheet and clear the password.

  • Consider Advanced Security: For highly sensitive information, explore additional security features within WPS Spreadsheet or your operating system.

Why Choose WPS Office for Your Work?

In today's digital world, finding the perfect office suite can be a daunting task. While Microsoft Office reigns supreme, its hefty price tag and subscription model often leave users searching for alternatives. Enter WPS Office, a completely free suite that packs a powerful punch when it comes to document creation and editing.

Beyond the Free Price Tag:

WPS Office features.


Sure, WPS Office being free is a major draw, but its benefits extend far beyond cost. Let's dive into some of its key advantages:

1. Seamless Compatibility:

WPS Office seamlessly opens, creates, edits, and saves all your existing Microsoft Office files, whether it's Word, Excel, or PowerPoint. No more conversion headaches! This seamless compatibility makes it easy to collaborate with colleagues and clients who might still be using the traditional Microsoft suite.

2. Feature-Rich Functionality:

Despite being free, WPS Office doesn't skimp on features. You'll find all the essentials you need, including word processing, spreadsheets, presentations, PDFs, and even cloud storage with WPS Cloud. The interface is familiar and intuitive, making it easy to jump right in and start working without a steep learning curve.

3. Online Document Collaboration:

WPS Office also shines in the online collaboration department. Its built-in cloud storage allows you to easily share documents with others and work on them in real-time, even if they're not using WPS Office themselves. This collaborative feature is a game-changer for teams working remotely or across different platforms.

4. Safe and Stable:

WPS Office takes your security seriously. It boasts regular updates, strong data encryption, and robust privacy features to keep your documents safe from prying eyes. You can work with confidence knowing your data is protected.

5. Beyond the Basics:

WPS Office goes beyond the basic office suite functionalities. It offers unique features like PDF signing, document repair, and a plethora of templates and tools to boost your productivity and creativity.

My Take on the Step-by-Step Processes:

Writing the step-by-step guides for WPS Office was truly enlightening. I was impressed by the ease of use and intuitive interface, making it even more accessible for users of all levels. The clear layout and familiar functionalities made creating the guides a smooth and enjoyable experience.

Overall, WPS Office is a compelling alternative to traditional office suites. With its feature-rich functionality, seamless compatibility, and focus on security and collaboration, it's definitely worth checking out. So, if you're looking for a powerful and free office solution, give WPS Office a try – you might just be surprised at what you find!

Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

FAQs

  1. How do you remove the password of a spreadsheet in WPS Office?

    Here's a more concise guide to removing passwords in WPS Spreadsheet:

Step 1: Open the password-protected file and access Security Options (Menu > Options > Security tab).

Step 2: Removing specific passwords:

  • Document password: Delete it under "File encryption options for this workbook."

  • Worksheet password: Click "Unprotect Sheet" on the Review tab and enter the password.

  • Workbook password: Click "Unprotect Workbook" on the Review tab and enter the password.

Step 3: Save the spreadsheet to make changes permanent.

Essential reminders:

  • Have the correct password for the protection type you're removing.

  • Save the file after removing the password.

  • Be cautious with sensitive data and consider alternative security measures if needed.

2. How do you lock cells without protecting the sheet in WPS Office?

Here's a condensed guide to locking cells without protecting the entire sheet in WPS Office (potential method):

Step 1: Select cells to lock.

Step 2: Right-click, choose "Format Cells," go to the "Protection" tab, and check "Locked."

Step 3: Save the spreadsheet.

Remember:

  • Users won't be able to edit locked cells unless they have the sheet password (if applicable).

  • To unlock cells, unprotect the sheet and uncheck "Locked."

  • This method might not be foolproof in all WPS Office versions. For foolproof protection, consider protecting the entire sheet with designated editable ranges.

Summary

The article provides a brief yet comprehensive guide to securing WPS Office spreadsheets, detailing three methods: locking for viewing/editing, enabling data entry, and setting unique sheet passwords. Emphasizing strong passwords and praising WPS Office's free, feature-rich nature, the guide is a concise and valuable resource for users aiming to enhance spreadsheet security.


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