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=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/13_fixing_a_row.m4v’]
Click on this link to download a file that you can use to learn how to fix row in Excel.