If you're working on sensitive information, such as a financial report for your business, this can help you ensure it stays protected.

Why have a password for Excel?Ĭreating a password for your Excel spreadsheets can prevent unauthorized individuals from accessing your work. In this article, we explain why you may choose to have a password in Excel and provide steps to help you add, remove or change your password on a PC or Mac device. If you're creating spreadsheets in Excel, you might benefit from learning about how to remove a password from a file. This program gives users the option to protect their work by adding a password to keep it more secure. Note: To see, instead, how to (un)lock a cell reference, see Freeze Cell in Formula or How to Anchor a Cell.Excel is a popular software program that many companies use to create spreadsheets and compile data. The pop-up warning is displayed, click Remove to confirm.Īs a result, the range B2:B9 is now unlocked and enabled for editing.Click on the recycle bin icon to delete the protection from the range.As you can see, the Sheet!B2:B9 range is protected. On the right side is the Protected sheets & ranges window.To see all protected ranges in Google Sheets, go to Data > Protected sheets and ranges.You can also unlock a range of cells or a sheet and enable changes in Google Sheets. If you need to lock the cells again, see How to Lock Cells or How to Password Protect a File. (If the sheet is not password-protected, skip this step.)Ĭells are now unlocked, and you can change them (e.g., change cell B2 from “Michael” to “Kevin”). If the sheet is password-protected, in the pop-up window, enter a password, and click OK.In the Ribbon, go to Review > Unprotect Sheet.Also, if you try to edit the content of the cell, you get the message that it is locked for changes.

If you select cell C2, you can see that all formatting options in the Home tab are grayed out, which means you can’t format the cell.

(If the sheet is password-protected, you’ll need to provide the password to unlock it.) Say you have the following sheet with cells locked for editing and formatting. If you have a protected worksheet or range of cells, you can easily unlock it. In this tutorial, you will learn how to unlock cells in Excel and Google Sheets.

Cara unprotect sheet excel