How can I make a vase with his own hands
How to choose the wall panels

How to put a password on excel document

How to put a password on the excel document

Various financial calculations are often made in an Excel spreadsheet. It is not desirable that this information to third parties fell.

Therefore there is a need to set a password on the Excel documents.

This can be done using the program itself.

You will need

  • PC, Excel 2003 program, the ability to work with spreadsheets



Download the software for electronicExcel 2003 spreadsheet (this is by far the most popular version). Create the desired table and make it calculations, filling it. You can simply open the finished Excel file containing the finished table. Files created with the help of this program have the extension .xls.


Once the file is open, proceed to create a password for this proceed as follows: •; find in the menu at the top of the window, click "Tools" and click on it with the left button of the murine
•; in the submenu, locate and click the mouse the line "Settings", resulting in open window-
•; find the "Security" tab and click the left button of the murine at the top
•; in "the book File Encryption Options" set password, and clicking on the button, in addition to select the type of encryption, it is recommended to leave one that is default setting
•; click «Ok» at the bottom of the window, and then again to confirm the selected password in the small window that appears in this case.


The next time the file is opened, the screenA window appears with a proposal to enter a password. If the set of entered characters will not match the one that was entered during the installation password, the file will not open.


Similarly, it is possible to protect a file tablethe changes. In this case, set the password in the "Sharing settings for this book." In this case, the one who does not know the password, will be able to view the contents of the file, but can not change it. Here you can recommend a read-only file and enter electronic signatures.


When setting a password, be extremely careful when you accidentally pressed the Caps Lock key or switch the language keyboard layout, can enter a password that is different from the plan.

Comments are closed.