The issue of data protection today is particularly relevant. The network is full of intruders who can easily seize unprotected information. In addition, there are cases when the user wants to establish protection simply from unauthorized eyes, for example, in case several people use the same computer. In general, now we will not figure out the motive of such desire, and let's talk better about how to pass excel file. In this article, under the sight was Excel version 2007 and 2010, after all, the principle of installing the password they will have identical. So, all those who want to establish protection for the Exele document, I propose to use one of two ways. What? Learn Next!
Fashion first
In fact, both methods are extremely simple, and equally functional, therefore it does not matter which you choose. It is also simple. So, let's start with the first method of execution algorithm:
- Let's imagine that the necessary document is ready, it remains only to pass it. To do this, press the large "Office" button in the upper left corner of the program.
- In the context menu that opens, click "Save As".
- A new window will open, your task is to pay attention to the small "service" button located next to "Save" and "Cancel". Click on it, and drops a small menu, select the "General Parameters" line.
- Next, you can set passwords for two cases: to open the document and changes. Enter the desired cipher and click "OK". From now on, every time you open the document to each user will be asked to introduce set password. Passwords are better to write down otherwise, if you forget, you will have to break your head.
Method of the second
In addition to the above, I can offer another option to set the password to the Excel document.
Adhering to such simple rules, you can install protection on any file in two accounts. excel programs. I note that the basis of this function is the 128-bit AES encryption, which is considered to be a standard file protection method.
Video to help
Very often refer to the question how to install a password on microsoft document Excel 2007/2010 So that the document is available to other users only in read mode. Today I will explain how to establish protection for changing the Excel file.
This information is designed primarily for newcomers, therefore replete large quantity Screenshotov I. detailed description Actions that the usual user may seem at absolutely not requiring comments. Please treat with understanding.
1. And so, we have an open XLSX document with the name Book 1.. Go to the tab FileAs shown in Figure 1.
Picture 1.
2. Here you choose the item Save asCircled red. 
Figure 2.
3. A document dialog box appears. At the bottom of the window, click the button Servicemarked with a red marker in Figure 3. 
Figure 3.
4. After that, a pop-up menu will appear. In it you need to choose the item Common parameters.
Figure 4.
5. We see the general parameter window where you can set the password both to open the file and change. In our case, you need to install a password only to change, so in the field Password for change We enter a password. 
Figure 5.
6. Next, press the button OK.
Figure 6.
7. In the password confirmation request window, we enter our password again, then press the button OK.
Figure 7.
8. The system returns us to dialog box Save a file where you press the button SaveCurved in the figure below. 
Figure 8.
9. And so, we have a XLSX document that is protected by a password for change. We try to open it. 
Figure 9.
10. When trying to open the file, the password for full access will be requested. In addition, as we see in Figure 10, we can open it in reading mode. 
Figure 10.
11. In the window title Microsoft Excel. It will be seen, the document is open in limited mode. 
Figure 11.
Sometimes it is necessary to make it so that access to the document does not receive nobody outsider. It happens quite difficult, if several people use one device. This article will describe how to install protection to files using standard tools, as well as how to remove protection, if it is no longer needed to the user.
Install the password in Office 2003
In the 2003 office for installing protection for Word and Excel, you need to go to tools menuand then proceed to parameters. On the Security tab, you can set protection that will open access to other people to view a file and a cipher that will allow you to edit the document.
After that will remain only apply Change And the file will be protected from viewing and editing.
Password protection in office 2007
Here you have to go to the main menuwhich starts when you click on the round button in the upper left corner. Here in the section " Prepare"The item" "will be present, you need to click on it, to open the settings window. 
Next, you must enter a set of characters, which will become cipher. You can delete it entering the file by entering the protective sequence, and then you need to go to this setting. After that, instead of cipher, it will be necessary to introduce an empty combination, i.e. Do not enter anything.
Installation of a password on Word and Excel 2010, 2013, 2016
To encrypt data, you will need to go to main menu, go to the information section, and then select the defense of the document and encrypt with password.
In the next menu you need to enter a combination for encryption. 
To remove the protection, you will need to go to the file, go to the same setting item, and leave the protective combination empty.
Such standard method Encryption will allow you to protect user data from viewing and editing, access to them can only be able to get those people to whom the user will transmit a combination. Hacked them not so easy, the built-in cipher reset means does not exist, there are conventional busting programs, and they require many resources and can work for a very long time. This is especially noticeable if the cipher consists of large number Signs and compiled in all the rules, and not a one word.
However, that is why the user itself needs to be carefully with passwords. If an important document is encrypted, then the combination should be as a user exactly will not forget, because it will be very difficult to pick it up.
Good time day, dear friends! How are you feeling? Personally, I have it Friday, but it's not ahti outside. Anyway. Please tell me, and what office package do you use? I am sure that most of you enjoy Microsoft Office.and I am no exception. And of course, everything is probably known about Excel. So you know that it turns out to be a built-in means of protection?
No, I do not mean antivirus. I mean what you can protect this document using the password. In one of my articles, I told, but I do not see sense to use the program presented in that article if you need to protect the Exele document or information that can be placed in a text document (for example names, passwords, etc.).
In general, today I will show you how to put a password to the Excel file if you still do not know. And all these methods work perfectly both in the 2010 version and in the version of 2013. We went!
Password protection for opening
Everything. Now leave Excel and open this document again. You will pop up the window where you need to enter your password. Just do not forget passwords from the document, otherwise, in contrast to other Internet services, you cannot restore e-mail or telephone.
Editing protection
In addition to usual password protection You can block some specific functions on separate sheetor on the whole book entirely. Let's see how it is done.
Well? Everything worked out? I think you should have had problems. But if all the same have problems, then contact. I will help you).
Alternative way
You can put a password and a little different way.
Now let's try to go to the saved document and see how it works in action. If you put both passwords, you first have to break through the opening protection, and then through protection for editing (or open a read document).
In general, as you see, the ways to protect the Exele document a whole bunch. So you can choose any.
Well, on this I finish an article. I really hope that these tips will be useful to you in life. Be sure to subscribe to updating my blog to keep abreast of all the most interesting. Best wishes to you. See you in other articles. Bye Bye!
Sincerely, Dmitry Kostin
Most computer users Uses in its daily work Microsoft Office. Quite often files with documentation may contain important informationwhich needs to be protected from third parties. In order for your documents to open and edit only you, the system has the opportunity to close their password. Not all users know about it.
Nevertheless, we have such an opportunity. In fact, put a password to the Excel or Word file and thereby protect it is quite easy, it is enough to do uncomplicated manipulations.
How to put a password to the Excel 2007 file
These actions are performed after you have created a document with the aforementioned name. First you need to open the Open item menu Save as.
In the window that appears, we find the button at the left side below Service, click and in the appeared list find Common parameters. In the newly opened window we find a string Password for opening.
It is recommended to invent an average and high degree of difficulty containing letters and numbers to reduce the probability of hacking an Excel file having important information. After you entered the password in the appropriate line, you will need to re-enter it, after clicking on OK. This operation exists in order to exclude an error when entering. The above actions are performed in the same way with Word documents.
How to put a password to the Excel file 2003
- After creating the file, you need to open the menu item File and choose a string called Save as.
- In the window that appears, looking for an item Service and in the pop-up menu find a line Common parameters.
- Next appears a window with a password request, fit
