How to fix/lock a reference to a row in Excel
In another post I have shown you how to create a reference to a locked/fixed cell. However at times we need to be able to fix a reference to a row. For example if you need to calculate a set of daily numbers against a differing daily exchange rate, it is very useful to be able to fix the reference to the row. This is what I will show you in this post. In another post I am also going to show you how to fix a reference to a column…
As always below the video there is a file you can download to practise on.