Protect

Mark Workbook as Final Excel offers options to mark Workbook as final. Marking a workbook as final discourages other users to edit it. Note that, users can edit the final version since it is not protected. Let’s follow the steps below: 1. Open a workbook (for example, Book1). 2. Click File and click Info. 3. […]

Make Workbook Read Only Excel has a built-in option to make a workbook read only. If you want to make a read-only workbook, follow the steps below. Note that you can still save the changes in a copy of the workbook. You can protect the sheet for better protection. 1. Open a workbook. 2. Go

Protect Excel Workbook This tutorial will show you how to protect Excel workbook from other users. That means other users cannot modify, insert, delete or do any type of changes in your workbook. Let’s follow the steps below: 1. Open a workbook. 2. On the Review tab, go to Protect group and click on Protect

Protect Excel Sheet In case of sharing a file with other users, you may want to protect Excel sheet from being changed. Follow the steps below: 1. Right click on the Sheet1 tab and select “Protect Sheet…”. 2. Enter a password (our password is “protect”). 3. Check the boxes to allow other users to work

Lock Cells in Excel Lock Specific Cells| Lock Formula Cells You can lock cells by using Excel’s built-in options. Locking a cell protects it from being edited by other users. We have divided this tutorial into three different sections: lock all cells, lock specific cells, and lock formula cells. Lock All Cells If you protect

Protect Excel File In order to protect Excel file, you can encrypt a file with a password. The encrypted file can not be opened without a password. Here is how you can password protect an Excel file. 1. Open a file in Excel. 2. Click the File tab and click Save as. 3. Click Browse.