Install a password on Excel opening. How to easily put a password to the Excel file to protect your document? Password deletion in Excel

Want to install or remove the password in the Excel file, but do not know how? Need to remove the protection, but forgot the password? Or are you just interested in nuances for hacking protection in Excel?

Answers to these questions, practice and a little theory - below, in this small article.

Want to be a crow? See a 2-minute video. No extra words:

Installing the opening password in Excel

Set the password in Excel in two ways. They are not obvious to everyone, but expected simple.

See yourself.

Method 1. When working with the document is over ...

  1. click the tab File (File)
  2. select Menu Information (info)
  3. click
  4. and select

In the window that appears, enter the password and confirm it to avoid errors when entering.

Easy, simple and reliable!

You just protect the file from the opening - encrypted all its contents using the password. it the most reliable way of protectionwhich is the hardest hack.

Valuable Council - Do not lose your password!

Also through the menu Intelligence You can install other password protection - on the book and page of the document. But keep in mind: Protecting books, pages, VBA macros is unreliable in all excel versions. Such protection is crashed instantly.

Method 2. The second way to install the password is even easier to first.

Keeping a document as usual (File (File) - Save as Save AS)...

  1. in the dialog box, click Service (Tools)
  2. and select the point in the menu General Options (General Options)

In a new window, enter your password and confirm its correctly by re-entering.


Here you can also install not only a password for opening a file, but also a password for recording changes (yes, it is also always instantly wagged).

Password deletion in Excel

When the file protection of the file cannot be removed from the document and do not worry about his loss.

The procedure for deleting the password from Excel is similar to its installation.

Open the document and through the tab File (File)...

  1. call the password input window (Menu Information (info)
  2. press the button PROTECT WORKBOOK
  3. select Encrypt with Password)
  4. just erase password and click OK

In the password saved after this document will not be.

Password recovery for Excel

Everything is easy and simple when the password is known. But what if the password is lost and the important data was not available?

The answer depends on the type of protection and the version of Excel, which creates a document.

Three options are possible:

Restoring Excel password. Weak defense

For different purposes in Excel there are various protection options. Passwords for some of them are or removed instantly, regardless of the complexity of the passwords themselves and the Excel version.

Excel passwords that can be instantly found or deleted:

  • password recording changes
  • password Protection Page
  • password working book
  • vBA password Macros
  • opening password for Excel 6-95

There is a whole class of programs to restore Excel passwords. It is difficult to allocate some of them - they all equally successfully cope with simple protection in Excel.

Password recovery Excel 97-2003. Reliable protection with a secret

Reliable protection in Excel documents of all versions (except an ancient Excel 6-95) is a discovery password: all the file content is fully encrypted and the document cannot be even open without a password.

Well, since the password is lost, we will look for a password, right?

No, not true! There is also a secret.

In fact, do not password encrypts the file, but encryption key - Special value that is obtained from cunning password transformations. You enter the password, Excel converts it to the encryption key and tries to decrypt the file. If the password is correct, then you get access to the data. If the password is incorrect, then the encryption key will be incorrect and the data will remain inaccessible.

It turns out to open an encrypted Excel file you can search for a password, and you can - the encryption key.

And here he is a secret - for Excel 97-2003 you need to look for a key encryption!

And that's why...

IN different versions Excel To calculate the key, different password conversion algorithms are used. The key at the same time has a strictly defined length, which does not depend on the complexity of the password or from its length.

In Excel 97-2003 at the encryption key, the fatally small length is only 40 bits.

The modern computer takes a day or two to go through all 2 40 possible key values \u200b\u200band find the desired one.

And there will be a key - there will be no password!

Programs that can do this not so much. One of them is Accent Office Password Recovery (in it this option is called "key search").

A couple of days on the key search is great but how about a couple of minutes?

With the help of so-called rainbow Tables Perhaps this!

Speaking simple language, Rainbow Table is a multiple gigabyte database that stores calculated in advance values \u200b\u200bfor checking the keys. Search in the rainbow table of the control value occupies a couple of minutes. After that, the Excel document can instantly decipher.

Neither the length of the password nor its complexity has absolutely no meaning. A couple of minutes and everything is no password!

Rainbow tables are used by some software manufacturers for password recovery and in online services that decrypt any Excel file loaded to them.

Vernidostostost.Ru - an example of such a service

Password recovery Excel 2007-2013. Flawlessly reliable defense

Jokes and secrets ended with the advent of Excel 2007. Since then, the level of protection is growing, and the speed of password hacking decreases with each new version Excel.

The encryption key length increased to 128/256 bits and cannot be found (many options 2 128 or 2 256 it is impossible to move simply). For the same reason, for Excel 2007-2013 there are no rainbow tables.

It remains to act in the forehead - to sort possible options passwords. In sequence.

And then they came to the rescue - video cards.

As it turned out, their power is suitable not only for super-terminal computer gamesBut for many other tasks.

So exactly and to recover Excel 2007-2013 passwords too.

The speed of passwords in just one video card can increase ten times, that is, the time of your expectation will decrease in tens of times.

Of course great! Connect one or two-all video cards to the password coupling and reduce your waiting time.

But pay attention: not all programs to restore Excel 2007-2013 passwords work on video cards. And those used them, do not always make it at high speed. We'll have to look, test, choose ...

Instead of the result

Summing up can be said: If you want to truly protect your data, use the opening password in Excel 2007-2013 documents and never lose it.

Now you know how to install a reliable password in two ways and know what to do if it is still lost.

Check yourself or what I exchanged my time

You have received useful practical knowledge. You learned:

  • passwords In Excel documents 2007-2010-2013 in two ways
  • delete password On the opening from Excel files 2007-2013 in a couple of clicks

And you have received many theoretical knowledge that will help you right now or in the future. You learned:

  • what's in Excel whole line password protection that always instantly wake up
  • what for EXCEL Password Closed 97-2003 need to look for the encryption keynot password
  • what to decrypt documents Excel 97-2003 there are online services
  • what to search for a password opening documents Excel 2007-2013 you need to use video cards
  • what is the main criteria when searching for a program for recovery excel password 2007-2013 - support video cards and password size

Method 1. (We use the program)

We are looking for in the search engine and load the program " Office. Password Recovery. Toolbox.", Which picks up passwords to the saved documents Microsoft Office.: MS Word, MS Excel, MS Outlook, MS Access databases and VBA projects. Please note that the passwords received will not be relatives, but will only be a randomly selected combination of symbols (these are the features of the password coding mechanism in Excel).

Method 2. (VBA)

Open menu Service - Macro - Editor Visual Basic ( or click Alt + F11) Insert a new module (menu Insert - Module. ) And copy this text there:

Sub password_cracker ()

DIM I AS INTEGER, J AS INTEGER, K AS INTEGER

Dim L AS Integer, M AS Integer, N AS Integer

Dim i1 AS Integer, I2 AS Integer, I3 AS Integer

Dim I4 AS Integer, I5 AS Integer, I6 AS Integer

Dim Kennwort AS String

ON ERROR RESUME NEXT

For i \u003d 65 to 66: For j \u003d 65 to 66: For k \u003d 65 to 66

For l \u003d 65 to 66: for m \u003d 65 to 66: For i1 \u003d 65 to 66

For i2 \u003d 65 to 66: for i3 \u003d 65 to 66: for i4 \u003d 65 to 66

For i5 \u003d 65 to 66: for i6 \u003d 65 to 66: for n \u003d 32 to 126

Kennwort \u003d CHR (I) & CHR (J) & CHR (K) & CHR (L) & CHR (M) & CHR (I1) & CHR (I2) & CHR (I3) & CHR (I4) & CHR (I5 ) & Chr (i6) & chr (n)

ActiveSheet.unProtect Kennwort.

If ActiveSheet.ProtectContents \u003d False Thatn

MSGBox "DONE" & VBCR & "ENJOY IT)"

Exit Sub.

End if

NEXT: Next: Next: Next: Next: Next

End Sub.

After performing this macro, passwords will be permanently removed from the Excel file.

Method 3. (for advanced users)

  1. Explanation:
    New office files are a container. Archive, if you want.
    You can open it through TotalCommander - put on it the cursor and click Ctrl + Pagedown.
    So on the way "File.xlsx / XL / Worksheets / Sheet1.xml"or " Sheet2."Or somehow differently, and the sheet is located. For example, there is in " Sheet1.«.
    1. pull out the file " Sheet1.xml.»From the XLSX container and open a text editor.
    2. Search by text We are looking for "PASS".
    3. The editor finds an XML container. Or something like this. In short container " sheetProtection.«.
    4. Kill the entire container " SheetProtection."From"<» до «>».
    5. Save the file.
    6. We throw back into the XLSX container.
    7. Climb up from the file
    8. Open the file double click And voila! Everything is working!

One of the most effective document protection methods is to install a password on it. Today, U. computer users It is possible to set a password to any document from microsoft package Office. If your Excel document contains important data that should not be seen to third parties, you can put a password to this document to ensure reliable protection.

How to set a password to an Excel document?

Almost every full-fledged spreadsheet editor has a password document protection function. Below we look at the procedure for installing a password for two popular programs - and free office package LibreOffice.

Installing a password in Microsoft Excel

1. Run Microsoft Excel, click on the menu button and go to the point "Prepare" - "Enchant Document" .

2. In the window that opens in the graph "Password" Enter anyone desired security key, the duration of which should not exceed 255 characters.

3. Confirm the password by specifying it again in the column "The confirmation" and then click on the button "OK" .

If you suddenly need, then you can do it by moving to the menu "Enchant Document" and then exposing in the graph "Password" and "The confirmation" Empty strings.

Installing the password in LibreOffice

1. Run the spreadsheet in LibreOffice, and then go to the menu "File" - "Save As" . In the displayed conductor, specify the folder where the copy of the document, extension will be saved, check the point near the item. "Save with password" and then click "OK" .

2. The password task window appears on the screen. Come up with any desired password, enter it in the first graph, and then repeat it in the second. Once you click the button "OK" The specified folder will appear a pellet copy of the document (if necessary, old copy Without a password, you can easily remove).

Password removal is carried out in the following way: Go back to the menu again "Save as" and make sure that the conductor opened is not a tick "Save with password" . After pressing the button "OK" A copy of the document will appear in the folder on the computer, but already as before, without a password.

Using such a simple data protection method, you can be confident in the confidentiality of your information.

Instruction

As with any document created in Microsoft Office, whether ACCESS or Word, Excel files (* .xls format) also support the password setting. After you have finished working with the document, click the "File" button in the top menu of the Microsoft Excel control. In the drop-down menu "File" you will see the item "Save As". Click on it with the left mouse button once. In the document saving window that appears next to the Save button, find the "Service" drop-down menu, click on the inverted triangle and the "General parameters" item appears.

A small "General Options" window will appear on the screen. In it, you must specify a password for opening a document and / or password to change the document. Here you can select the "Recommend Read Just" checkbox so that the Excel toolbar is disabled by default. In case you set the password only to open the document, each time you open your table, you will need to enter the password, while any user, passwordcan edit the data in the tables and create a new one. When installing a password to change the document, the opening of the file will occur as usual, without requesting any passwords, but after making new data to the table, when you try to save the document, you will need to enter a password. Print the installation Both passwords will need a double input when opening and closing the document. Moreover, passwords on the opening of the Excel file and on its editing may not coincide.

After the password or pair of passwords is entered, click the "OK" button in the "General parameters" window, after which in the Explorer window, enter the document name and click "Save".

note

Remember that when you loss the password, you will not be able to open the document in any way. The password is entered once and is displayed as an asterisk, so pay attention whether it is not included Caps Lock..

Sources:

  • how to put a password on Excel Document

Various financial calculations are often produced in Excel spreadsheets. It is extremely undesirable that this information gets to third parties. Therefore, it is necessary to install a password for Excel documents. This can be done with the program itself.

You will need

Instruction

Download the program to work with electronic excel Tables 2003 (this is today the most popular version). Create the desired table and make calculations in it by filling it with it. You can simply open a ready-made Excel file containing a ready-made table. Files created using this program have extension .xls.

After the file is open, proceed to creating a password, for this, follow these steps: Find on the menu, at the top of the window "Service" point and click on it with the left mouse button;
In the submenu that opens, find and click the "Parameters" string, as a result of which the window opens;
At the top of the window, find the "Security" tab and click on it with the left mouse button;
In the "Encryption Parameters of this Book file" section, set the password, and by clicking the button, additionally select the type of encryption, it is recommended to leave the one that is worth the default;
Click the "OK" button at the bottom of the window, after which you again confirm the selected password in a small window, which will appear.

Hello everyone, sometimes you want to secure your documents, and therefore the question arises: how to put a password to the Excel file? Usually K. personal computer There are often access to several users, and if someone makes changes to your documents, it will be impossible to correct.

Therefore, I propose to familiarize yourself with the simple and effective way protect your data in the Excel file. You can use this method on all version of Microsoft Excel.

We start installing a password on a document in microsoft program Excel. In fact, you can put two passwords for each file. One is set to open and read the file, and the other for making changes in the document. Therefore, pay attention to this, since if you put a password only for reading, another user having a password will be able to make changes to the file.

Open Microsoft Excel document.

The save window will open and select "SERVICE" at the bottom of the window, and then "General Parameters"

To make it easier to figure out, look at the picture:

A separate window will open, where you can set a password for our document:

If you need to install a password and writing, I enter the password in the next window twice in a row:

Now you can check how Microsoft Excel document will open.

Open a document, and should get out such a window with a password input request.