Excel data encryption and protection methods: worksheet and workbook protection, and modify permission settings

Worksheet Protection

Excel data production is complete, to protect the worksheet data from being modified, you can set Excel data protection to ensure the accuracy of the data.convert word to pdf with embedded excel files Now share two ways to set data protection.

Method 1:Worksheet Protection

Here the limitations of editing is divided into two teaching methods, respectively, to protect the management of the worksheet, protect their workbook. The two development methods are responsible for the region is also different, but they can be set up to study the method is almost the same, we first look together to see how to pass the setup, and then talk to you about the difference between the two mutual information function.

Click the excel toolbar "review". In the protection module, we can see two function buttons: protect worksheet and protect workbook.jpg to pdf converter and combine Click them and enter the password to complete the encryption.

However, there is a difference between Protect Sheet and Protect Workbook as follows.

Protect Sheet protects the data content of the worksheet, i.e., the data in the cells. When we set Protect Sheet, most of the functions in the Excel function bar are not available.

Protect the workbook is to protect the entire worksheet, that is, we can edit the cell, but can not edit the properties of the worksheet, such as deleting, moving, copying, renaming the worksheet.

Excel set restrictions on editing, in the open excel file is not any other one of the prompts, we teachers can manage the contents of the file management through the view, but the enterprise can see for themselves the editing system function bar in most of the buttons are grayed out.word to pdf converter online free i love pdf This means that important documents are set to limit editing.


Both Worksheet Protection and Workbook Protection are password protected, so if we want to remove the protection, we need to enter the password.

If we forget the password, we can try more passwords that we have used or we can use tools to help us solve the problem.

Forget to protect the worksheet, protect the workbook password, choose to use the unlimited password function, no password when a key to remove the password

Method 2: Modify permissions

Next is the last method to set password for excel. Its function is similar to the restriction of editing, just set up in a different way, there are ways to solve the problem of forgetting the password in time. Let's see how to set it.

Save the file as, in the choice to save the development path of the interface, we are not in a hurry to save, click on the bottom of the tool through the button, select the use of general management options

Then, we choose to change the permissions in the input box after the password to be set. Click "OK" to save the file.

When you open a file with modified permissions, you will be prompted to enter the password if you want to edit the file, otherwise it will enter read-only mode. In fact, you can edit the file even if it is in read-only mode. We just need to rename the file and save it in a new path to get the edited file, but the protected file still exists.


What are the wireless technologies for the Internet of Things and what are their advantages and disadvantages?

Internet of Things applications have penetrated into our lives, and Internet of Things projects can be applied in all aspects. qcm6125 So, what are the wireless...

What is an OLED display?

Organic light-emitting diode (OLED) is an advanced LED(light-emitting diode) technology.Leds use backplanes to provide a uniform light source for all pixels. Or...

More and more people are not installing quartz countertops in the kitchen, which is popular now, at least for more than 10 years

The common countertop materials on the market are natural stone, kitchen benchtops stone stainless steel, quartz stone. Now the kitchen decoration, the choice o...

There are several kinds of egg jumping. Girls often use egg jumping

Jumping eggs is a very good sex toys, can increase the excitement of sex. It can be placed inside the vagina for women and around the head of the penis for men....

Couples erotic products, how to birth industry unicorn?

What do you mean by couple erotic products?There are two main categories: contraceptives and sex toys. We know more about family planning supplies, mainly refer...

Advantages of several common iot communication technologies

The Internet of Things is the product of the combination of communication technology, computers and the Internet, which can realize the functions of connection ...

Four Cold Facts About Sex That Are Good for You to Know

On the topic of sex, we usually only focus on the more common knowledge, but in fact, there are also for many issues interesting and fascinating cold knowledge....

The quality management of quartz stone plate is good or bad, which aspect can be reflected in detail

At present, we are familiar with quartz stone, it is one of the most ideal materials for counters, quartz slab and it is also the most used material. Quartz sto...

How about doing a Google search? Don't you know these benefits?

Today, Google Search engine optimization has become an essential part of any marketing promotion strategy. seo ranking optimization However, most foreign trade ...

Massage and kneading the abdomen has many benefits, promote intestinal peristalsis, eliminate constipation, but also help sleep

Abdominal rubbing can increase the blood flow of the abdominal muscles and intestinal smooth muscles, increase the muscle tone of the gastrointestinal lining an...