The issue of data protection is particularly relevant today. The network is full of attackers who can easily take over unprotected information. In addition, there are often cases when the user simply wants to install protection from prying eyes, for example, if several people use the same computer. In general, now we will not find out the motive for such a desire, but rather talk about how to password protect an excel file. In this article, Excel versions 2007 and 2010 were targeted, because the principle of setting a password for them will be identical. So, for everyone who wants to install protection on an Excel document, I suggest using one of two methods. Which ones? Find out further!
Method one
In fact, both methods are extremely simple and equally functional, so it doesn’t matter which one you choose. It's also simple. So, let's start with the algorithm for performing the first method:
- Let's imagine that the required document is ready, all that remains is to password protect it. To do this, click the large “Office” button in the upper left corner of the program.
- In the opened context menu 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 a small menu will appear, select the line “ General Settings».
- Next, you can set passwords for two cases: for opening a document and changing it. Enter the desired code and click “OK”. From now on, every time a document is opened, each user will be prompted to enter set password. It’s better to write down your passwords somewhere, otherwise, if you forget, you’ll have to rack your brains.
Method two
In addition to the above, I can offer one more option for setting a password on an Excel document.
By following these simple rules, you can install protection on any Excel file in no time. I note that this feature is based on 128-bit AES encryption, which is considered the standard method of file protection.
Video to help
Most computer users use the package in their daily work Microsoft Office. Quite often, documentation files may contain important information, which must be protected from third parties. To ensure that only you can open and edit your documents, the system has the ability to lock them with a password. Not all users know about this.
Nevertheless, we have such an opportunity. In fact, it’s quite easy to put a password on an Excel or Word file and thereby protect it; you just need to do some simple manipulations.
How to put a password on an Excel 2007 file
These steps are performed after you have created a document with the above name. First you need to use the menu to open the item Save as.
In the window that appears, find the button on the bottom left side Service, click and find in the list that appears General Settings. In the newly opened window we find the line Password to open.
It is recommended to come up with medium to high complexity containing letters and numbers to reduce the likelihood of an Excel file containing sensitive information being hacked. After you have entered the password in the appropriate line, you will need to enter it again after clicking on OK. This operation exists to eliminate typing errors. The above steps work exactly the same with Word documents.
How to put a password on an Excel 2003 file
- After creating the file, you need to open the menu item File and select the line with the name Save as.
- In the window that appears, look for the item Service and in the pop-up menu we find the line General Settings.
- Next, a window appears asking for a password, enter and save all changes.
After the above steps, you can try to open your document again to make sure it has a password.
Today we will discuss how to password protect an Excel file. This tool included with Microsoft Office. The Excel program makes it possible to create tables of varying complexity, use formulas, as well as individual design. All current versions applications support setting a password.
Instructions
Let's move on to a step-by-step description of the process of how to password protect an Excel file. This opportunity is provided to files in *.xls format, like any other Microsoft Office documents, including Word and Access. So, after finishing working with the document, click the “File” button, which is located in the menu at the top of the window Microsoft Excel. In the list that appears, go to the “Save As” item by clicking on it once with the left mouse button. A window for saving the document will appear, in it we find the “Tools” menu, click the inverted triangle, and then use the “General Settings” function that appears.
Settings
Let's move on to the next stage of solving the question of how to password protect an Excel file. The “General Settings” section appears on the screen. Here you must enter a password to change or open a document. In addition, if you enable the Read-Only feature, when you try to open a password-protected Excel file, will be disabled by default.
If you set protection only to run a document, you will be prompted for input every time you open a table. In this case, all users who know the secret combination will be able to create arrays and edit data. Regarding the question of how to open a password-protected file, the protection is set to change the material, the launch will occur as standard, without any requests. However, if you add new data to the table and try to save the document, the application will ask you to provide a secret combination.
When both types of passwords are set, double entry is required when starting and closing the material. It is important to know that you can set different passwords for editing and opening a file.
Let's return to the settings. When the password (or a pair of them) is set, click the “OK” button in the “General Settings”. In Explorer, enter the name of the document and save the file using the appropriate function.
Removing protection
Next, we will discuss how to disable a password in Excel application. To solve the problem, no additional software is needed, since the function is provided by the built-in tools of the application.
Let's launch Excel. Open the document that needs to be removed from password protection. We use the "File" menu. We indicate “Save as”, and then open the “Tools” menu. Go to “General Settings”, double-click on the asterisks in the password line. Use the “Del” key for the desired action. Confirm the operation by pressing the “OK” button. Click “Save” and then “Yes” in the new window.
That's it, the password is in Excel workbook removed. With a leaf everything happens in a similar way. Open the “Tools” menu and use the “Unprotect” command. To confirm the cancellation action, you will have to enter the previously assigned password. From now on, you know how to password protect an Excel file, as well as how to cancel the protection if necessary.
Good day to everyone, dear friends! How are you? Personally, I have it on Friday, but it’s not so hot on the street. Oh well. Please tell me, what office package do you use? I'm sure most of you use Microsoft Office, and I'm no exception. And of course, everyone probably knows about Excel too. So, did you know that Excel has a built-in security feature?
No, I don't mean antivirus. What I mean is that you can protect this document with a password. I talked about it in one of my articles, but I don’t see the point in using the program presented in that article if you need to protect an Excel 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 on an excel file, if you don’t already know it. Moreover, all these methods work perfectly in both version 2010 and version 2013. Let's go!
Password protection for opening
All. Now exit Excel and open this document again. A window will pop up where you will need to enter your password. Just don’t forget the document passwords, otherwise, unlike other Internet services, you won’t be able to recover them by email or phone.
Edit protection
In addition to the usual password protection, you can block some specific functions on a separate sheet, or on the entire workbook. Let's see how it's done.
Well? Did everything work out? I think you shouldn't have any problems. But if you still have problems, please contact us. I'll help you).
Alternative way
You can set a password in a slightly different way.
Now let's try to go into the saved document and see how it works in action. If you set both passwords, then first you will have to break through the opening protection, and then through the editing protection (or open the document read-only).
In general, as you can see, there are a whole bunch of ways to protect an Excel document. So you can choose any one.
Well, this is where I end the article. I really hope that these tips will be useful to you in life. Be sure to subscribe to my blog updates to stay up to date with all the most interesting things. All the best to you. See you in other articles. Bye bye!
Best regards, Dmitry Kostin
Many people put passwords on certain documents. If the file for a long time was not used, the secret word may be forgotten. It’s not always possible to remember it, but there are still ways to open the document.
Let's look at how you can remove a password in an Excel file.
Removing the password in an Excel file using a script
You can open a password-protected document using the free VBA script Excel Password Remover. After downloading the program, you need to run it. The utility will immediately integrate into Excel, which will display a message about running the macro. You can safely run it, after which you should open your password-protected file and select “Straxx” from the Excel menu.
The important thing is that the script does not attempt to crack the Excel password by selecting random phrases; it disables the security call in the document from the inside, which is much simpler. The entire procedure takes about 2 minutes.
Removing the password from an Excel document manually
You can remove the password in an Excel file or manually.
- To do this, you need to open the document, go to the “File” tab, select “Information”, and then in the list that opens, the “Permissions” heading.
- In the new window, click “Encrypt with password”, after which a window will open in which the previously entered password will be displayed. You need to delete it and click on the OK button.
- Close the document. The application will ask you to save the changes, you must click on the "Yes" button.
- Run the document again and you will see that Excel will not require you to enter a password.
How to crack a password in Excel: an easy way
It is worth touching on such an important issue: how to password protect an Excel file. The presented tool is integral part Microsoft Office. Excel allows you to create tables of varying levels of complexity, apply formulas, and change the design. Today, all versions of the program support setting a password.
Detailed instructions
The description of the process can be divided into several stages. Files in the *.xls format, as well as any other Microsoft Office documents, including Word and Access, allow you to password-protect Excel materials. To complete the procedure, you need to do the following:
1. At the end of the process, click “File”. It is located in the menu at the top of the Microsoft Excel window.
2. When the list appears, you need to go to the “Save As” section. To do this, click on it with the left mouse button.
3. In the file saving window, find the “Tools” menu and click the inverted triangle.
4. After this, the “General Settings” function will appear, which must be applied.
Setting up a password
Now you should move on to the main steps to password protect an Excel file. When the “General Settings” section appears, you will need to enter a password that will allow you to enter the document and also edit it if necessary. When Read Only is enabled, the toolbar is disabled by default when a password is set. When protecting a document only for its launch, the prompt for input occurs constantly at the moment the table is opened. In order to use it, as well as edit its data, you need to know the secret combination.
To open a password-protected Excel file, provided that the protection is set to change the material, the launch is carried out as standard, without making any requests. Difficulties arise when entering new data into the table, as well as when trying to save the document. As a result, the user will be required to enter a secret combination. Setting both types of passwords requires double entry during the process of opening and closing the file.
It is worth noting that you can set different passwords for opening and editing material. Now we need to go back to the settings. After the password has been created, you need to click “OK”, which is located in “General Settings”. In Explorer you need to enter the name of the file and save it using the appropriate function.
Instructions
As with any document created in Microsoft Office, be it Access or Word, Excel files (*.xls format) also support setting a password. Once you have finished working with the document, click the "File" button in the top Microsoft Excel control menu. In the "File" drop-down menu, you will see a "Save As" option. Click on it with the left mouse button once. In the window that appears for saving the document, next to the “Save” button, find the “Tools” drop-down menu, click on the inverted triangle and the “General Settings” item that appears.
A small General Settings window will appear on the screen. In it you must specify a password to open the document and/or a password to change the document. Here you can also check the “Recommend Read Only” checkbox so that the Excel toolbar is disabled by default. In case you set a password only for opening a document, each time you open your spreadsheet, you will be required to enter a password, and any user knows the password, will be able to edit data in tables and create new ones. When you set a password to change a document, the file will be opened as usual, without prompting for any passwords, but after entering new data into the table, when you try to save the document, you will be required to enter a password. During installation Both passwords will need to be entered twice when opening and closing a document. Moreover, the passwords for opening an Excel file and for editing it may not be the same.
After a password or pair of passwords has been entered, click the “OK” button in the “General Settings” window, then enter the document name in the Explorer window and click “Save”.
Please note
Remember that if you lose your password, you will not be able to open the document in any way. The password is entered once and is displayed as asterisks, so pay attention to whether Caps Lock is turned on.
Sources:
- how to put a password on an excel document
Various financial calculations are often performed in Excel spreadsheets. It is highly undesirable for this information to reach third parties. Therefore, it becomes necessary to set a password on Excel documents. This can be done using the program itself.
You will need
- PC, Excel program 2003, ability to work with spreadsheets
Instructions
Download Excel 2003 spreadsheet software (this is by far the most popular version). Create the required table and make calculations in it by filling it out. You can simply open a ready-made Excel file containing a ready-made table. Files created with this program have the extension .xls.
After the file is opened, proceed to create a password, to do this, follow these steps: find the “Service” item in the menu at the top of the window and left-click on it;
in the submenu that opens, find and click on the “Options” line, which will open a window;
at the top of the window, find the “Security” tab and left-click on it;
in the “File encryption options for this book” section, set a password, and by clicking on the button, additionally select the encryption type; it is recommended to leave the default one;
Click the “Ok” button at the bottom of the window, and then confirm the selected password again in the small window that appears.
Data security is a burning topic for many computer users, especially if we're talking about about PCs that are used by several people at once. Almost every computer is connected to the Internet, and it is no secret that a large number of virus programs, some of which can transmit important information from the user’s computer to attacker servers. In addition, hackers are also capable of hacking someone else's cloud storage, where many people store data for comfortable work with them across multiple devices at once.
All of the above suggests that at any moment this or that file can be lost and end up in “ bad hands" If we are talking about a Word or Excel file, this may be an important document, the loss of which is undesirable and sometimes dangerous. Some users store text documents important passwords, others create unique content (write scripts or books), and all this may end up in the hands of attackers. To avoid this situation, you can store documents in archives that have a password. But it is much more convenient to use built-in functions text editors, and from this article you will learn how to put a password on a Word or Excel document without using third-party programs.
We recommend reading:Setting a password in Word 2003 (Excel 2003)
The programs of the Microsoft Office 2003 suite have become very widespread, and many users still do not give up on them. They are often installed on low-power office computers, in schools, institutes and wherever necessary Word programs, Excel, PowerPoint and others with basic functions.
It was in Office 2003 applications that for the first time it became possible to set a password for a Word or Excel document. To do this you need:
Please note that for each specific document created on a computer, you must set a password separately.
Setting a password in Word 2007 (Excel 2007)
The most common package in Russia office applications is Microsoft Office 2007. Over the years, it has not lost its popularity, and millions of people are accustomed to working with it. Password protect Word or Excel documents from office suite 2007 can be done as follows:
Important: If you want to remove the set password from the document, repeat the procedure for setting it, but instead of the entered password, leave a blank line and click “OK”. In this case, Microsoft Office will automatically determine that the user wants to remove the password from Word document(Excel) and will not force you to repeat the command, as happens during its installation.
Setting a password in Word 2010, 2013, 2016 (Excel 2010, 2013, 2016)
The process of setting a password for a document in modern versions of office applications from Microsoft is not much different from the option for Office 2007. However modern programs received new design, and it wouldn’t hurt to give an example:
The process for deactivating a password in Word 2010 and later versions is identical to how it works in Word 2007.
Important: If encryption Word file or Excel took place in modern Microsoft versions Office (after 2010) or in the online version of the Office 365 program, you cannot open the document in Word 2007 and earlier versions.
Most computer users use in their daily work Microsoft package Office. Quite often, documentation files may contain important information that needs to be protected from third parties. To ensure that only you can open and edit your documents, the system has the ability to lock them with a password. Not all users know about this.
Nevertheless, we have such an opportunity. In fact, it’s quite easy to put a password on an Excel or Word file and thereby protect it; you just need to do some simple manipulations.
How to put a password on an Excel 2007 file
These steps are performed after you have created a document with the above name. First you need to use the menu to open the item Save as.
In the window that appears, find the button on the bottom left side Service, click and find in the list that appears General Settings. In the newly opened window we find the line Password to open.
It is recommended to come up with medium to high complexity containing letters and numbers to reduce the likelihood of an Excel file containing sensitive information being hacked. After you have entered the password in the appropriate line, you will need to enter it again after clicking on OK. This operation exists to eliminate typing errors. The above steps work exactly the same with Word documents.
How to put a password on an Excel 2003 file
- After creating the file, you need to open the menu item File and select the line with the name Save as.
- In the window that appears, look for the item Service and in the pop-up menu we find the line General Settings.
- Next, a window appears asking for a password, enter
