Click the “Protect Workbook” button and then choose “Encrypt with Password” from the dropdown menu.
You’ll see the “Info” category by default. To set it up, open your Excel file and head to the File menu. You have three choices when it comes to protecting an entire Excel workbook: encrypt the workbook with a password, make the workbook read-only, or protect just the structure of a workbook. You can even combine the protection of those different levels for different effects. Technically this method involves protecting a worksheet and then allowing certain cells to be exempt from that protection. Cell: You can also protect just specific cells on a worksheet from being changed.Worksheet: You can protect the data on individual worksheets from being changed.And you protect the structure of a workbook so that anyone can open it, but they need a password to rearrange, rename, delete, or create new worksheets. You can make the file open as read-only by default so that people have to opt into editing it. You can encrypt it with a password to limit who can even open it. Workbook: You have a few options for protecting a workbook.Protection in Microsoft Excel is password-based and happens at three different levels. Fortunately, Microsoft Excel provides some pretty good tools for preventing people from editing various parts of a workbook.
