When it's done, save your changes.Īfter protecting the worksheet with password, users will only be able to view the contents of your Excel sheet, and unable to edit your existing sheets.
HOW TO PASSWORD PROTECT EXCEL PASSWORD
HOW TO PASSWORD PROTECT EXCEL HOW TO
In this tutorial we'll show you how to set a password to protect Worksheet in Excel 2016 / 2013, making your worksheet ready only. When to use: You are sharing the file and want others to view, but not edit, a worksheet Click on the Review tab and choose Protect Sheet. Confirm the password in the Reenter Password box, and then select OK. Enter a password in the Password box, and then select OK. If you want to prevent specific worksheets from being edited or deleted, you can lock them with a password. Select the Protect Workbook box and choose Encrypt with Password.
Given below are the steps to protect your sheet. In addition to protecting workbooks and worksheets, you can also protect formulas.
A password prevents other people from removing the worksheet protectionit needs to be entered to unprotect the sheet. To remove protection, simply remove the password. An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns. Additionally, you can also specify a password to lock your worksheet.
0 kommentar(er)
