Protect Sheet - If you want to protect any sheet, you can click Protect Sheet. Go to the Review tab and click Protect Sheet or Protect Workbook under the Protect section. Open the excel files you want to protect. There is a couple of methods we can take to password protect excel file. In order to protect data security and personal privacy, we will teach you how to password protect excel files and how to lock excel files on Windows and Mac. How to password protect excel files? What will you store on your table? Sensitive data, complex reports for work just done, or score ranking tables, if these files are accidentally changed by others, it will cause confusion.