In this video, I show you how to lock, hide (formulas) and protect Excel worksheets and workbooks. You can also password protect your settings, but make sure to take note of the password and store it in a secure place in case you forget the password as passwords cannot be recovered if forgotten.
Select cells to lock/unlock/hide (formulas). Right click – Format Cells – Protection Tab & choose settings. Review Tab – Protect Sheet/Workbook, select permissions, enter a password if desired and save.