Right-click inside the cell that contains the formula and select Format cells from the context menu. This will allow an Excel user to copy the cell reference to other cells while locking the reference point For example take A1. An Absolute Reference can be created by typing a in front of either the row or column of a cell reference.
When you select this option the button will be added to the Quick Access Toolbar at the top of the workbook.
This time check the Locked option and click okay. In the format cells dialog box select the Protection tab. The most common way of preventing people from tampering with your Excel formulas is to Protect the worksheet. After selecting the Find Select option other options will appear under it from which select Go To Special option.