The process of adding to the front of rows or columns is known as anchoring and it is compatible with all versions of Excel. The cells under the yellow column headers have to multiply the relevant cells under the green column headers by a fixed factor for the city mentioned in each row. Then click OK to lock the cell formula in excel.
Check the Locked option.
Press F4 on your keyboard. Select the formula cell or a range of formula cells which you need to lock the value then click Kutools More. Select the cells you want to lock. In the format cells.