When you want to send your Excel worksheet, it’s important to protect the data that you’re sharing. Luckily Excel provides some pretty good tools for preventing people from editing various parts of a workbook. In this tutorial, we will help you to protect a workbook ** in Excel*. Let’s get into this article!! Get an official version of * MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Steps to Protect a Workbook:
Please follow the below steps to protect a workbook.
- First, open the Excel and Click on the “File” tab from the “Ribbon”.
- Here, you need to click the “Info” section from the left navigation sidebar, under that, you can see the “Protect Workbook” option.
- Click the Protect Workbook, it will expand the drop-down list as shown below.
- You need to select the “Encrypt with Password” option from the list.
- It will show the “Encrypt Document” window, and here you need to type the password then click the OK button.
- After that it will open the “Confirm Password” window, here you need to reenter the password to confirm and click the OK button.
- Finally, your workbook is protected, now you can see the “Protect Workbook” button will be highlighted.
- Next time when you open the file you will need to enter the password.
Conclusion:
Here, we have described the step-by-step procedure to protect a workbook in Excel. Make use of this. If you have any doubts, feel free to share them with us. To learn more, check out Geek Excel
Top comments (0)