Click Encrypt Workbooks , select your target files or folders, enter the desired password, and click OK.
Standard Excel only allows you to protect one file at a time. Kutools adds "Batch" capabilities to these security tasks. kutools for excel password work
Ensure your version of Kutools is compatible with your Office build (e.g., Office 365 vs. Excel 2019). The Final Verdict Click Encrypt Workbooks , select your target files