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.

[flowplayer src=’’]



Click on this link to download a file that you can use to learn how to fix row in Excel.