FIX ROW IN EXCEL

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...