Right-click on the sheet tab and select "Protect Sheet". In the "Protect Sheet" dialog box, ensure that all of the options are checked under "Protect worksheet.
Go to the protection tab and check Locked option and click Ok. Go to Review tab, click Protect Sheet and protect the sheet using a password. Now only certain.
This article will take you through the steps in Microsoft Excel needed to conduct backtesting. We will mainly use two powerful excel built-in functions.