How to fix/lock a reference to a row in Excel
In another post I have shown you how to make a cell fixed or absolute and in another one, I’ve shown you how to fix a column reference in a formula.
In this one I want to show you how to fix a row in a formula.
As always here is the file for you to practise on.