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.
Dec 09, 2010 |
Microsoft Office Computers & Internet