Mark a workbook as final in Excel to indicate that this is the final version of your workbook. Only use this feature to discourage editing. Users can still edit the workbook. 1. Open a workbook. 2. On the File tab, click Info. 3. Click Protect Workbook, Mark as Final. 4. Click OK. Result. Note: users […]
This example shows you how to make your workbook read-only. Users can still save changes by creating a new copy of the workbook. For a better protection, protect a sheet. 1. Open a workbook. 2. On the File tab, click Save As. 3. Click Browse. 4. Click on the Tools button and click General Options. […]
You can lock cells in Excel if you want to protect cells from being edited. In this example, we will lock cell A2. Before you start: by default, all cells are locked. However, locking cells has no effect until you protect the worksheet. So when you protect a worksheet, all your cells (=worksheet) will be […]
When you share an Excel file with other users, you may want to protect a worksheet to help prevent it from being changed. 1. Right click a worksheet tab. 2. Click Protect Sheet. 3. Enter a password. 4. Check the actions you allow the users of your worksheet to perform. 5. Click OK. Note: if […]
This example teaches you how to protect the workbook structure in Excel. If you protect the workbook structure, users cannot insert, delete, rename, move, copy, hide or unhide worksheets anymore. 1. Open a workbook. 2. On the Review tab, in the Changes group, click Protect Workbook. 3. Check Structure, enter a password and click OK. […]
Encrypt an Excel file with a password so that it requires a password to open it. 1. Open a workbook. 2. On the File tab, click Save As. 3. Click Browse. 4. Click on the Tools button and click General Options. 5. In the Password to open box, enter a password and click OK. 6. […]
First of all you need to know the difference about Protect the worksheet, protect the workbook and protect the file. To know about this, click here. To prevent others from viewing hidden worksheets, adding, moving, deleting, hiding worksheets, and renaming them, you can protect the structure of your Excel workbook with a smart password. Protect […]
Protecting the worksheet restricts the reader to change, edit or move the data in worksheet. Note: Protecting the worksheet is different feature from Protecting the MS file and Restrict Editing MS Word File. Protecting the Worksheet in MS Excel is an excellent feature that allow the writer to restrict the reader to change the content of […]
