Tip & How-To about Computers & Internet

How to password protect Microsoft Office Excel 2003

Excel, a part of the Microsoft Office suit, offer password protect feature to prevent unauthorized users from viewing or modifying a *.xls (Microsoft Excel) file data, we can password protect MS Excel 2003 files so that only certain people can control the information.

Before Excel 2003 password protecting, here are a couple of notes:

1. Before password-protecting a workbook or worksheet, you have to consider writing down the password and keep it secure. That way, if you lose or forgot the Excel password, it will be easier to recover the information.
2. Excel has two types of password. One is "password to open" and the other one is "password to modify". You can password-protect the worksheet against modifications so that give some people read-only access to a workbook, or you can password-protect the workbook against opening an entire workbook of multiple worksheets.
3. Microsoft Excel supports several types of encryption settings, including Microsoft Base Cryptographic Provider V1.0, Microsoft DH Schnabel Cryptographic Provider, Microsoft Strong Cryptographic Provider, and more. However, password protecting an Excel file does not 100% guarantee that the password can not be decrypted or the password hacked. You can learn more about how to recover Excel password from SmartKey official site.

Now follow these steps to password-protect Excel 2003.

Step 1: Save your *.xls Excel file
Point to the File Menu, click save as and input the file name then the *.xls file is saved on your local disc. Point to "Tools" - "Options". When the "Options" multi-tabbed dialog box appears, click the "Security" tab.

Step 2: Choose the password protect type

  • If you don't wish other users to view your Excel workbook, enter a password in the "Password to open" box, and then click OK.

  • If you agree other users to view your Excel workbook but don't want them make changes to the workbook, type a password in the "Password to modify" box.

  • If you wish to use a different encryption settings type, click Advanced, choose an encryption setting type you want in the list, and then click OK. And you can also specify the number of characters in the Choose a key length box.


Step3: Confirm your password
After type your password, a "Confirm Password" box will prompted, retype your passwords to confirm, then click OK.

Step4: Resave the Excel spreadsheet.
After password protecting your Excel file, click Save. All the steps are finished.

Tips:

All the original articles are authorized by SmartKey, welcome To Transshipment but Please Retain the original.

If you are interesting in Excel Password Recovery, please visit our website.

Posted by on

Computers & Internet Logo

Related Topics:

Related Questions:

2 Answers

How we protect the excel sheet by password.


follow these steps to password-protect Excel file
Step 1: Save your *.xls Excel file Point to the File Menu, click save as and input the file name then the *.xls file is saved on your local disc. Point to "Tools" - "Options". When the "Options" multi-tabbed dialog box appears, click the "Security" tab.
Step 2: Choose the password protect type • If you don't wish other users to view your Excel workbook, enter a password in the "Password to open" box, and then click OK.
• If you agree other users to view your Excel workbook but don't want them make changes to the workbook, type a password in the "Password to modify" box.
• If you wish to use a different encryption settings type, click Advanced, choose an encryption setting type you want in the list, and then click OK. And you can also specify the number of characters in the Choose a key length box.
Step3: Confirm your password After type your password, a "Confirm Password" box will prompted, retype your passwords to confirm, then click OK.
Step4: Resave the Excel spreadsheet. After password protecting your Excel file, click Save. All the steps are finished.
read more: http://blog.recoverlostpassword.com/how-to-password-protect-microsoft-office-excel-2003.html

Dec 09, 2010 | Microsoft Office Standard 2007: Windows

1 Answer

How to unlock a forgotten Excel xls password


thanks for sharing such useful article!

Jun 30, 2010 | Computers & Internet

6 Answers

how do I unlock an excel spreadsheet which has password protection (lost). I am using Mac Excel not Windows


A) Open document > Select edit menu > choose select all > then choose copy from edit menu.
Open new document > edit menu> paste.
Select tools menu> choose options> window opens with options. Select form different tabs the edit tab> make sure that al desired boxes are selected.
Select save tab>choose and mark box>ask about properties
accept or Apply options and close.
Save new document different name. When saving it should ask if you want to save properties> choose not save. Maybe it asks if you want to modify properties> choose yes> select box archive amongst read only, hidden or archive.
If this does not work.
B)There are many 3rd party utilities which claim to reset forgotten word password:
The program that I recommend is the Excel Password Recovery 5.0 It recovers/removes the "Password to Open" and "Password to Edit" for you to view and edit the document freely.
http://www.recoverlostpassword.com/products/excelpasswordrecovery.html

May 06, 2010 | Microsoft EXCEL MAC UPGRADE 2008 Upgrade...

Not finding what you are looking for?

296 people viewed this tip

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Loading...