Both WPS Spreadsheets and Microsoft Excel have the function of document encryption.

For users' actual needs, WPS Spreadsheets additionally provide two practical features: Encryption at different levels and Password hints.

In Microsoft, two methods are available for document encryption.

Method 1

Click the Protect Workbook drop-down button in the Info interface and select Encrypt with Password.

We can only set a password for the excel document in the pop-up dialog but not make it read-only or backed up.

Method 2

The second method is to save the document as another.

In this way, we can set the password to open or modify and make it read-only and backed up.

Compared with Microsoft Excel, WPS Spreadsheets has two additional features.

They are Protection at different levels and Password hint.

Open your Spreadsheets document, click Menu, click Options and select Security in the pop-up dialog.

· 1. Encryption at different levels

We can click Advanced to set different levels of encryption for this document according to our needs.

· 2. Password hint.

We can set Password hint in case we forget our passwords.

Here we enter wps as a password and confirm it by reentering. In the Password hint area, we input My study course.

With a number of files at work, we are likely to forget our document passwords.

When we have failed twice, a password hint will appear. In this example, the sight of My study course can remind us that the password is relevant to our courses.

For convenience, WPS Spreadsheets provide a single but handy way of encryption with all the relevant settings centralized within one interface.

In this interface, we can set the password to open or modify and make it read-only and backed up. It is also convenient for users to set or remove password.