Microsoft Excel is one of the programs in the Microsoft Office suite. Excel allows you to create tables of varying complexity using formulas and custom design. The most popular editions are Excel 2003, 2007 and 2010. All of them support setting a password.
Instructions
Step 1
As with any document created in Microsoft Office, be it Access or Word, Excel files (*.xls format) also support setting a password. After you have finished working with the document, click the "File" button in the top control menu of Microsoft Excel. In the drop-down menu "File" you will see the item "Save As". Click on it with the left mouse button once. In the window that appears to save the document, next to the "Save" button, find the drop-down menu "Service", click on the inverted triangle and the item "General Options" that appears.
Step 2
A small window "General parameters" will appear on the screen. In it, you must specify a password to open a document and / or a password to change a document. Here you can also check the box "Recommend read-only" so that the Excel toolbar is disabled by default. If you set a password only for opening the document, each time you open your spreadsheet, you will need to enter a password, and any user who knows password, will be able to edit data in tables and create new arrays. When setting 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 trying to save the document, you will need to enter a password. Setting both passwords requires double entry when opening and closing a document. Moreover, the passwords for opening an Excel file and for editing it may not coincide.
Step 3
After the password or password pair is entered, click the “OK” button in the “General settings” window, then enter the document name in the explorer window and click “Save”.
