Opposite of ($) in Excel Formulas

[turtlepokerman]

Hello fellow Excel Users,

I am looking for a way to have a the row number change when copying formulas horizontally. By copying I mean dragging the little box on the right hand side of the formula cell to the right. I did not know if there was an easy way to have the row reference number instead of the column letter. Any help is greatly appreciated.

Thanks,
turtlepokerman

 

[shg]

      -A-- -B-- -C-- -D-- -E-- -F-- -G--
  1   $A$1 $A$1 $A$2 $A$3 $A$4 $A$5 $A$6
  2   $A$2                              
  3   $A$3                              
  4   $A$4                              
  5   $A$5                              
  6   $A$6

In B1 and copy right,

=INDEX($A:$A, COLUMNS($A1:A1))

 

[turtlepokerman]

Nice that worked. I'm surprised that Excel has not created a non-absolute symbol yet, so that we do not have to go through the sometimes confusing INDEX function.

Thanks