Subtitles of the Movie

If you wish to protect an entire file in Excel, you can assign a password, so that someone needs to know the password in order to even open to read the file, or in order to make changes to the file. To protect this file using a password, go to the file menu, to the save as command. In this screen there is a menu called tools. And at the bottom of the tool menu is a general options area. There are 2 different passwords that you can set to a file. The password to open will not allow a user to open or even look at the contents of a file, unless they know the password. Once again I'll use the password of lock. I'll have to re-enter that password and click ok. Then click the save button to make sure that this change is saved to the file. Then I'll click yes to replace the existing edit data file. To test to see whether the password applies, we have to close the file and then re-open it, through the file menu. It informs us that this file is now protected and we must know the password in order to get in. We could click the cancel button, which would cancel the whole open command and we would not be able to see the file. If we try to click ok without entering a password, it tells us that we must not bypass this screen in order to get to the file. I'll click OK - once again try to open the file and this time type in the password. When I click ok it will allow me to open, look at and even edit the data in the file. I can even save changes that I've made to that file clicking these save button. The other kind of password that you can place on a file is called a read only or a password to modify. This will allow the user to open and look at a file, but if they want to make changes to it they must save it under a different file name, which protects the original document from being modified. To change this type of a password we'll go back to the file menu to save as. In the tools menu select general options. We'll delete the password to open and type our password in the password to modify area. Once again I'll use the password of lock, click ok and re-enter it to confirm it. Then click the save button and click yes to replace the existing edit data file. To test this we'll close the file and try to re-open it. A slightly different password screen appears this time. If I don't know the password I can cancel the operation and not open the file, or click the read only button. This allows me to come into the file and take a look at it. I can even change the data in the file. But if I try to save those changes to the same file called edit data, it will inform me that it's read only. To save a copy of the file I can click ok, and give the file a different name or save it to a different location. This will protect our original edit data file with the information that was there before. I'll click save and now notice this file is now called edit data2. I'll close this file and then re-open the original edit data file. This time I'll type in the password and click ok. Now the file opens no longer in read only mode. If I make a change, which notice, the change I made before is not saved here, I had changed this amount of 13.62 to 20 dollars. But that is now stored in this separate file, called edit data 2. If I make that change here and click the save button it allows me to update this original file since I knew the password to get out of the read only mode. These 2 passwords, both located under the save as command in the file menu, under tools, to general options, can both be used to protect your files and workbooks in Excel. I'm going to delete the passwords from these boxes thereby removing the protection from my workbook. Click ok, click save again and replace the existing file. words from these boxes thereby removing the protection from my workbook. Click ok, click save again and replace the existing file.