N
I want to put a password for my excel sheet,so that expect me nobody cant access it.please tell me how to protect my excel sheet.pls explain in detail(proper procedure)
password
How To Password Protect a Worksheet:
1. From Tools menu choose Protection. Slide right to Protect Sheet to open the Protect Sheet dialog box.
2. Select the required options.
3. Enter a password in the Password (optional) text box to prevent unauthorized users from removing sheet protection.
4. Click OK to open the Confirm Password dialog box.
5. Enter the same password in the Reenter password to proceed box.
6. Click OK.
How to Password Protect Part of a Worksheet:
1. Select the range of cells that you want users to be able to modify.
* The rest of the cells will be protected.
2. From Format menu choose Cells to open the Format Cells dialog box.
3. Click on the Protection tab.
4. Enter a password in the Password (optional) text box to prevent unauthorized users from removing sheet protection.
5. Clear the locked check box to unlock the selected range of cells.
6. Click OK to close the Format Cells dialog box.
7. Optional: Protect the password following the steps given above.
1. From Tools menu choose Protection. Slide right to Protect Sheet to open the Protect Sheet dialog box.
2. Select the required options.
3. Enter a password in the Password (optional) text box to prevent unauthorized users from removing sheet protection.
4. Click OK to open the Confirm Password dialog box.
5. Enter the same password in the Reenter password to proceed box.
6. Click OK.
How to Password Protect Part of a Worksheet:
1. Select the range of cells that you want users to be able to modify.
* The rest of the cells will be protected.
2. From Format menu choose Cells to open the Format Cells dialog box.
3. Click on the Protection tab.
4. Enter a password in the Password (optional) text box to prevent unauthorized users from removing sheet protection.
5. Clear the locked check box to unlock the selected range of cells.
6. Click OK to close the Format Cells dialog box.
7. Optional: Protect the password following the steps given above.
G
The solution posted by gagandeep is true. You may try this.
Also there is alnernate process to protect your sheet with password.
1) From the file menu, choose Save As option.
2) in the Save As dislog box, popup the tools option and select General Option from it.
3) From Save option dialog box, provide a password in "Password to Open" and in "Password to Modify" box.
4) then Click on Ok button, You have to ask to reenter your password, do it 2 times.
Your whole workbook is now password protected.
Also there is alnernate process to protect your sheet with password.
1) From the file menu, choose Save As option.
2) in the Save As dislog box, popup the tools option and select General Option from it.
3) From Save option dialog box, provide a password in "Password to Open" and in "Password to Modify" box.
4) then Click on Ok button, You have to ask to reenter your password, do it 2 times.
Your whole workbook is now password protected.
^^Yes, the above can also be done while saving a Worksheet.