Protect Excel With password Both Worksheet or Workbook on Mac

protect excel

Do you know you can protect your specific sheet or even the complete workbook ? So in this guide i will show you how you can Protect Excel With password on both your Sheet and Workbook in Macbook.

So before that let us understand

What is Difference between Sheet and Workbook In Excel ?

If you are a excel user you must be knowing what is a workbook. A workbook is a file that contains one or more worksheets to help you organize data.

In Excel, we call sheet as a worksheet. A worksheet is a single page that contains its own collection of cells and rows to help you organize your data.

How to Protect Excel With password For Workbook in Mac ?

Follow the instruction to enable password protection for your complete workbook.

  1. Open a blank or existing Workbook
  2. Point your cursor towards the top bar of excel
  3. Click on Tools
  4. Now you will be seeing multiple options, click on protection
  5. Select Protect workbook option
  1. Now provide your wished password click OK and you are all set.

Now you have successfully protected your complete workbook. When you open the workbook you will see for a password field.

How to Protect Excel With password For Worksheet in Mac ?
  1. Open a blank or existing Workbook
  2. Click on the particular Sheet which you wanted to protect
  3. Point your cursor towards the top bar of excel
  4. Click on Tools
  5. Now you will be seeing multiple options, click on protection
  6. Select Protect Sheet option
  7. And Choose the options you want to lock or unlock for the user and give password and Lock it.

Note: Password is Optional, if you click on Ok without any password it will lock the Sheet by default.

Conclusion

It is always recommended if you have some important or sensitive information keep it safe with password protection. In this guide you have a very clear steps to Protect Excel With password the whole workbook as well a particular worksheet in your Macbook.

Leave a Reply

Your email address will not be published. Required fields are marked *